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

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;