--Script used to monitor application profile changes
--Threshold is the number of days to query for profile changes
--All profile changes that have occurred in the past 7 days
--will be displayed with the following query. -raj
select a.last_update_date
,(select user_name
from fnd_user
where user_id = a.last_updated_by) updated_by
,b.user_profile_option_name
,a.profile_option_value
,b.description
,b.application_id
from fnd_profile_option_values a,
FND_PROFILE_OPTIONS_VL b
where a.last_update_date > (sysdate-7)
and a.profile_option_id = b.profile_option_id
order by last_update_date desc, updated_by;
Wednesday, December 28, 2011
Wednesday, November 30, 2011
Java Concurrent Program Info
The MOS docs may be of help to some extent to get through the JCPs:
827563.1 - How To Create a Java Concurrent Program?
827575.1 - Java Concurrent Program FAQ
186301.1 - How to register and execute Java Concurrent Program ?in Oracle Applications R11i ?
305710.1 - A SAMPLE JAVA CONCURRENT PROGRAM
827563.1 - How To Create a Java Concurrent Program?
827575.1 - Java Concurrent Program FAQ
186301.1 - How to register and execute Java Concurrent Program ?in Oracle Applications R11i ?
305710.1 - A SAMPLE JAVA CONCURRENT PROGRAM
Query for R12 Shortnames and Product Status
To know R12 Application Short Names and Application Names:
SELECT APPLICATION_SHORT_NAME SHORT_NAME,
APPLICATION_NAME
FROM FND_APPLICATION FND ,
FND_APPLICATION_TL FNDTL
WHERE FND.APPLICATION_ID=FNDTL.APPLICATION_ID
ORDER BY 1;
SHORT_NAME APPLICATION_NAME
ABM Activity Based Management (Obsolete)
AD Applications DBA
AHL Complex Maintenance Repair and Overhaul
AHM Hosting Manager(Obsolete)
AK Common Modules-AK
ALR Alert
AME Approvals Management
AMF Fulfillment Services (Obsolete)
AMS Marketing
AMV Marketing Encyclopedia System
AMW Internal Controls Manager
AN Sales Analysis
AR Receivables
AS Sales Foundation
ASF Sales Online
ASG CRM Gateway for Mobile Devices
ASL Sales Offline
ASN Sales
ASO Order Capture
ASP Oracle Sales for Handhelds
AST TeleSales
AU Application Utilities
AX Global Accounting Engine
AZ Application Implementation
BEN Advanced Benefits
BIC Customer Intelligence (obsolete)
BIE eCommerce Intelligence
BIL Sales Intelligence
BIM Marketing Intelligence
BIN Communications Intelligence
BIS Applications BIS
BIV Service Intelligence
BIX Interaction Center Intelligence
BIY Systems Intelligence
BLC Utility Billing
BNE Web Applications Desktop Integrator
BOM Bills of Material
BSC Balanced Scorecard
CCT Telephony Manager
CDR Oracle Clinical Data Repository
CE Cash Management
CHV Supplier Scheduling
CLA APAC Consulting Localizations
CLE EMEA Consulting Localizations
CLJ Japan Consulting Localizations
CLL LAD Consulting Localizations
CLN Supply Chain Trading Connector for RosettaNet
CN Incentive Compensation
CPGC CPG - CDOA
CRP Capacity
CS Service
CSC Customer Care
CSD Depot Repair
CSE Asset Tracking
CSF Field Service
CSI Install Base
CSL Field Service/Laptop
CSM Field Service/Palm
CSN Call Center
CSP Spares Management
CSR Scheduler
CSS Support (obsolete)
CST Cost Management
CTB Clinical Transaction Base
CUA Capital Resource Logistics - Assets
CUC Revenue Accounting
CUE Billing Connect (obsolete)
CUF Capital Resource Logistics - Financials
CUG Citizen Interaction Center
CUI Network Logistics - Inventory
CUN Network Logistics - NATS (obsolete)
CUP Network Logistics - Purchasing
CUR Mass Market Receivables for Comms
CUS Network Logistics
CZ Configurator
DDD CADView-3D
DDR Demand Signal Repository
DEM01 Team 01 Order Entry Demo
DNA Development
DOM Document Managment and Collaboration
DPP Oracle Price Protection
DT DateTrack
DUMMY_GMO Obsolete Process Operations
EAA SEM Exchange (obsolete)
EAM Enterprise Asset Management
EC e-Commerce Gateway
ECX XML Gateway
EDR E-Records
EGO Advanced Product Catalog
EMS Environment Management System
ENG Engineering
ENI Product Intelligence
EVM Value Based Management
FEM Enterprise Performance Foundation
FF FastFormula
FII Financial Intelligence
FLM Flow Manufacturing
FND Application Object Library
FPA Project Portfolio Analysis
FPT Banking Center (obsolete)
FRM Report Manager
FTE Transportation Execution
FTP Transfer Pricing
FUN Financials Common Modules
FV Federal Financials
GCS Financial Consolidation Hub
GHR US Federal Human Resources
GMA Process Manufacturing Systems
GMD Process Manufacturing Product Development
GME Process Manufacturing Process Execution
GMF Process Manufacturing Financials
GMI Process Manufacturing Inventory
GML Process Manufacturing Logistics
GMO Manufacturing Execution System for Process Manufacturing
GMP Process Manufacturing Process Planning
GMS Grants Accounting
GMW Process Manufacturing Portal
GNI Genealogy Intelligence
GR Process Manufacturing Regulatory Management
HCA Healthcare
HCC iHCConnect
HCN iHCIntegrate
HCP Healthcare Intelligence
HCT Healthcare Terminology Server
HRI Human Resources Intelligence
HXC Time and Labor Engine
HXT Time and Labor
IA iAssets
IAM Digital Asset Management
IBA iMarketing (Obsolete)
IBC Content Manager
IBE iStore
IBP Bill Presentment & Payment
IBT iAuction
IBU iSupport
IBW Oracle Web Analytics
IBY Payments
ICX Oracle iProcurement
IEB Interaction Blending
IEC Advanced Outbound Telephony
IEM Email Center
IEO Interaction Center Technology
IEP Predictive
IES Scripting
IET Call Center Connectors
IEU Universal Work Queue
IEV IVR Integrator
IEX Collections
IGC Contract Commitment
IGF Financial Aid
IGI Public Sector Financials International
IGS Student System
IGW Grants Proposal
IMC Customers Online
IMT iMeeting (obsolete)
INL Oracle Landed Cost Management
INV Inventory
IPA Capital Resource Logistics - Projects
IPD Product Development (obsolete)
IPM Oracle Imaging Process Management
IRC iRecruitment
ISC Supply Chain Intelligence
ISX iSettlement
ITA Information Technology Audit
ITG Internet Procurement Enterprise Connector
IZU Oracle E-Business Suite Diagnostics
JA Asia/Pacific Localizations
JE European Localizations
JG Regional Localizations
JL Latin America Localizations
JMF Supply Chain Localizations
JTF CRM Foundation
JTM Mobile Application Foundation
JTS CRM Self Service Administration
LNS Loans
ME Controlled Availability Product(Obsolete)
MFG Manufacturing
MIA Mobile Applications for Inventory Management
MIV Media Interactive
MQA Mobile Quality Applications
MRP Master Scheduling/MRP
MSC Advanced Supply Chain Planning
MSD Demand Planning
MSO Constraint Based Optimization
MSR Inventory Optimization
MST Transportation Planning
MTH Oracle Manufacturing Operations Center
MWA Mobile Applications
OAM Oracle Applications Manager
ODQ Data Query
OE Order Entry
OFA Assets
OKB Contracts for Subscriptions (Obsolete)
OKC Contracts Core
OKC_REP_TXT_INDEX_OPTIMIZE Optimize Contracts Repository Text index
OKC_REP_TXT_INDEX_SYNC Build/syncronize Contracts Repository Text index
OKE Project Contracts
OKI Contracts Intelligence
OKL Lease and Finance Management
OKO Contracts for Sales (Obsolete)
OKP Contracts for Procurement (Obsolete)
OKR Contracts for Rights (Obsolete)
OKS Service Contracts
OKT Royalty Management
OKX Contracts Integration
ONT Order Management
OPI Operations Intelligence
OTA Learning Management
OUC University Curriculum
OZF Trade Management
OZP Trade Planning (Obsolete)
OZS iClaims (Obsolete)
PA Projects
PAY Payroll
PBR Budgeting and Planning
PER Human Resources
PFT Oracle Profitability Manager
PJI Project Intelligence
PJM Project Manufacturing
PMI Process Manufacturing Intelligence
PN Property Manager
PO Purchasing
POA Purchasing Intelligence
POM Exchange
PON Sourcing
POS iSupplier Portal
PQH Public Sector HR
PQP Public Sector Payroll
PRP Proposals
PSA Public Sector Financials
PSB Public Sector Budgeting
PSP Labor Distribution
PSR Public Sector Receivables
PTX Patch Tracking System
PV Partner Management
QA Quality
QOT Quoting
QP Advanced Pricing
QPR Oracle Deal Management
QRM Risk Management
RCM Regulatory Capital Manager (obsolete)
RG Application Report Generator
RHX Advanced Planning Foundation(obsolete)
RLA Release Management Integration Kit (Obsolete)
RLM Release Management
RMG Risk Manager
RRC Retail Core
RRS Site Management
SHT Applications Shared Technology
SQLAP Payables
SQLGL General Ledger
SSP SSP
SYSADMIN System Administration
TEST test
VEA Automotive
VEH Automotive Integration Kit (Obsolete)
WIP Work in Process
WMA Manufacturing Mobile Applications
WMS Warehouse Management
WPS Manufacturing Scheduling
WSH Shipping Execution
WSM Shop Floor Management
XBIL Business Online Interface
XBOL Business Online
XDO XML Publisher
XDP Provisioning
XLA Subledger Accounting
XLE Legal Entity Configurator
XNA Service Assurance for Communications
XNB Oracle Telecommunications Billing Integrator
XNC Sales for Communications (Obsolete)
XNI Install Base Intelligence (Obsolete)
XNM Marketing for Communications (Obsolete)
XNP Number Portability
XNS Service for Communications (obsolete)
XNT TeleBusiness for Telecom/Utilities
XTR Treasury
ZFA Financial Analyzer
ZPB Enterprise Planning and Budgeting
ZSA Sales Analyzer
ZX E-Business Tax
"Is it not cool how much Oracle applications grew?!!!"
To know R12 Product Installation Status
SELECT DECODE (NVL (a.APPLICATION_short_name, 'Not Found'),
'SQLAP', 'AP', 'SQLGL', 'GL', 'OFA', 'FA',
'Not Found', 'id ' || TO_CHAR (fpi.application_id),
a.APPLICATION_short_name) apps,
a1.APPLICATION_NAME NAME,
DECODE (fpi.status,
'I', 'Installed',
'S', 'Shared',
'N', 'Inactive',
fpi.status) status,
fpi.product_version,
NVL (fpi.patch_level, '-- Not Available --') Patchset,
TO_CHAR (fpi.last_update_date, 'dd-Mon-RRRR') "Update Date"
FROM FND_ORACLE_USERID o,
FND_APPLICATION a,
FND_PRODUCT_INSTALLATIONS fpi,
FND_APPLICATION_TL a1
WHERE fpi.application_id = a.application_id(+)
AND fpi.oracle_id = o.oracle_id(+)
AND a.APPLICATION_ID = a1.APPLICATION_ID
ORDER BY 3, 1, 2;
SELECT APPLICATION_SHORT_NAME SHORT_NAME,
APPLICATION_NAME
FROM FND_APPLICATION FND ,
FND_APPLICATION_TL FNDTL
WHERE FND.APPLICATION_ID=FNDTL.APPLICATION_ID
ORDER BY 1;
SHORT_NAME APPLICATION_NAME
ABM Activity Based Management (Obsolete)
AD Applications DBA
AHL Complex Maintenance Repair and Overhaul
AHM Hosting Manager(Obsolete)
AK Common Modules-AK
ALR Alert
AME Approvals Management
AMF Fulfillment Services (Obsolete)
AMS Marketing
AMV Marketing Encyclopedia System
AMW Internal Controls Manager
AN Sales Analysis
AR Receivables
AS Sales Foundation
ASF Sales Online
ASG CRM Gateway for Mobile Devices
ASL Sales Offline
ASN Sales
ASO Order Capture
ASP Oracle Sales for Handhelds
AST TeleSales
AU Application Utilities
AX Global Accounting Engine
AZ Application Implementation
BEN Advanced Benefits
BIC Customer Intelligence (obsolete)
BIE eCommerce Intelligence
BIL Sales Intelligence
BIM Marketing Intelligence
BIN Communications Intelligence
BIS Applications BIS
BIV Service Intelligence
BIX Interaction Center Intelligence
BIY Systems Intelligence
BLC Utility Billing
BNE Web Applications Desktop Integrator
BOM Bills of Material
BSC Balanced Scorecard
CCT Telephony Manager
CDR Oracle Clinical Data Repository
CE Cash Management
CHV Supplier Scheduling
CLA APAC Consulting Localizations
CLE EMEA Consulting Localizations
CLJ Japan Consulting Localizations
CLL LAD Consulting Localizations
CLN Supply Chain Trading Connector for RosettaNet
CN Incentive Compensation
CPGC CPG - CDOA
CRP Capacity
CS Service
CSC Customer Care
CSD Depot Repair
CSE Asset Tracking
CSF Field Service
CSI Install Base
CSL Field Service/Laptop
CSM Field Service/Palm
CSN Call Center
CSP Spares Management
CSR Scheduler
CSS Support (obsolete)
CST Cost Management
CTB Clinical Transaction Base
CUA Capital Resource Logistics - Assets
CUC Revenue Accounting
CUE Billing Connect (obsolete)
CUF Capital Resource Logistics - Financials
CUG Citizen Interaction Center
CUI Network Logistics - Inventory
CUN Network Logistics - NATS (obsolete)
CUP Network Logistics - Purchasing
CUR Mass Market Receivables for Comms
CUS Network Logistics
CZ Configurator
DDD CADView-3D
DDR Demand Signal Repository
DEM01 Team 01 Order Entry Demo
DNA Development
DOM Document Managment and Collaboration
DPP Oracle Price Protection
DT DateTrack
DUMMY_GMO Obsolete Process Operations
EAA SEM Exchange (obsolete)
EAM Enterprise Asset Management
EC e-Commerce Gateway
ECX XML Gateway
EDR E-Records
EGO Advanced Product Catalog
EMS Environment Management System
ENG Engineering
ENI Product Intelligence
EVM Value Based Management
FEM Enterprise Performance Foundation
FF FastFormula
FII Financial Intelligence
FLM Flow Manufacturing
FND Application Object Library
FPA Project Portfolio Analysis
FPT Banking Center (obsolete)
FRM Report Manager
FTE Transportation Execution
FTP Transfer Pricing
FUN Financials Common Modules
FV Federal Financials
GCS Financial Consolidation Hub
GHR US Federal Human Resources
GMA Process Manufacturing Systems
GMD Process Manufacturing Product Development
GME Process Manufacturing Process Execution
GMF Process Manufacturing Financials
GMI Process Manufacturing Inventory
GML Process Manufacturing Logistics
GMO Manufacturing Execution System for Process Manufacturing
GMP Process Manufacturing Process Planning
GMS Grants Accounting
GMW Process Manufacturing Portal
GNI Genealogy Intelligence
GR Process Manufacturing Regulatory Management
HCA Healthcare
HCC iHCConnect
HCN iHCIntegrate
HCP Healthcare Intelligence
HCT Healthcare Terminology Server
HRI Human Resources Intelligence
HXC Time and Labor Engine
HXT Time and Labor
IA iAssets
IAM Digital Asset Management
IBA iMarketing (Obsolete)
IBC Content Manager
IBE iStore
IBP Bill Presentment & Payment
IBT iAuction
IBU iSupport
IBW Oracle Web Analytics
IBY Payments
ICX Oracle iProcurement
IEB Interaction Blending
IEC Advanced Outbound Telephony
IEM Email Center
IEO Interaction Center Technology
IEP Predictive
IES Scripting
IET Call Center Connectors
IEU Universal Work Queue
IEV IVR Integrator
IEX Collections
IGC Contract Commitment
IGF Financial Aid
IGI Public Sector Financials International
IGS Student System
IGW Grants Proposal
IMC Customers Online
IMT iMeeting (obsolete)
INL Oracle Landed Cost Management
INV Inventory
IPA Capital Resource Logistics - Projects
IPD Product Development (obsolete)
IPM Oracle Imaging Process Management
IRC iRecruitment
ISC Supply Chain Intelligence
ISX iSettlement
ITA Information Technology Audit
ITG Internet Procurement Enterprise Connector
IZU Oracle E-Business Suite Diagnostics
JA Asia/Pacific Localizations
JE European Localizations
JG Regional Localizations
JL Latin America Localizations
JMF Supply Chain Localizations
JTF CRM Foundation
JTM Mobile Application Foundation
JTS CRM Self Service Administration
LNS Loans
ME Controlled Availability Product(Obsolete)
MFG Manufacturing
MIA Mobile Applications for Inventory Management
MIV Media Interactive
MQA Mobile Quality Applications
MRP Master Scheduling/MRP
MSC Advanced Supply Chain Planning
MSD Demand Planning
MSO Constraint Based Optimization
MSR Inventory Optimization
MST Transportation Planning
MTH Oracle Manufacturing Operations Center
MWA Mobile Applications
OAM Oracle Applications Manager
ODQ Data Query
OE Order Entry
OFA Assets
OKB Contracts for Subscriptions (Obsolete)
OKC Contracts Core
OKC_REP_TXT_INDEX_OPTIMIZE Optimize Contracts Repository Text index
OKC_REP_TXT_INDEX_SYNC Build/syncronize Contracts Repository Text index
OKE Project Contracts
OKI Contracts Intelligence
OKL Lease and Finance Management
OKO Contracts for Sales (Obsolete)
OKP Contracts for Procurement (Obsolete)
OKR Contracts for Rights (Obsolete)
OKS Service Contracts
OKT Royalty Management
OKX Contracts Integration
ONT Order Management
OPI Operations Intelligence
OTA Learning Management
OUC University Curriculum
OZF Trade Management
OZP Trade Planning (Obsolete)
OZS iClaims (Obsolete)
PA Projects
PAY Payroll
PBR Budgeting and Planning
PER Human Resources
PFT Oracle Profitability Manager
PJI Project Intelligence
PJM Project Manufacturing
PMI Process Manufacturing Intelligence
PN Property Manager
PO Purchasing
POA Purchasing Intelligence
POM Exchange
PON Sourcing
POS iSupplier Portal
PQH Public Sector HR
PQP Public Sector Payroll
PRP Proposals
PSA Public Sector Financials
PSB Public Sector Budgeting
PSP Labor Distribution
PSR Public Sector Receivables
PTX Patch Tracking System
PV Partner Management
QA Quality
QOT Quoting
QP Advanced Pricing
QPR Oracle Deal Management
QRM Risk Management
RCM Regulatory Capital Manager (obsolete)
RG Application Report Generator
RHX Advanced Planning Foundation(obsolete)
RLA Release Management Integration Kit (Obsolete)
RLM Release Management
RMG Risk Manager
RRC Retail Core
RRS Site Management
SHT Applications Shared Technology
SQLAP Payables
SQLGL General Ledger
SSP SSP
SYSADMIN System Administration
TEST test
VEA Automotive
VEH Automotive Integration Kit (Obsolete)
WIP Work in Process
WMA Manufacturing Mobile Applications
WMS Warehouse Management
WPS Manufacturing Scheduling
WSH Shipping Execution
WSM Shop Floor Management
XBIL Business Online Interface
XBOL Business Online
XDO XML Publisher
XDP Provisioning
XLA Subledger Accounting
XLE Legal Entity Configurator
XNA Service Assurance for Communications
XNB Oracle Telecommunications Billing Integrator
XNC Sales for Communications (Obsolete)
XNI Install Base Intelligence (Obsolete)
XNM Marketing for Communications (Obsolete)
XNP Number Portability
XNS Service for Communications (obsolete)
XNT TeleBusiness for Telecom/Utilities
XTR Treasury
ZFA Financial Analyzer
ZPB Enterprise Planning and Budgeting
ZSA Sales Analyzer
ZX E-Business Tax
"Is it not cool how much Oracle applications grew?!!!"
To know R12 Product Installation Status
SELECT DECODE (NVL (a.APPLICATION_short_name, 'Not Found'),
'SQLAP', 'AP', 'SQLGL', 'GL', 'OFA', 'FA',
'Not Found', 'id ' || TO_CHAR (fpi.application_id),
a.APPLICATION_short_name) apps,
a1.APPLICATION_NAME NAME,
DECODE (fpi.status,
'I', 'Installed',
'S', 'Shared',
'N', 'Inactive',
fpi.status) status,
fpi.product_version,
NVL (fpi.patch_level, '-- Not Available --') Patchset,
TO_CHAR (fpi.last_update_date, 'dd-Mon-RRRR') "Update Date"
FROM FND_ORACLE_USERID o,
FND_APPLICATION a,
FND_PRODUCT_INSTALLATIONS fpi,
FND_APPLICATION_TL a1
WHERE fpi.application_id = a.application_id(+)
AND fpi.oracle_id = o.oracle_id(+)
AND a.APPLICATION_ID = a1.APPLICATION_ID
ORDER BY 3, 1, 2;
Subscribe to:
Posts (Atom)