Important for Windows Oracle Apps customer

Unlike UNIX oracle apps ,Windows bit different and tricky to clean the old instance .  If your a Windows R12 oracle apps customer this post will be very useful .  Please follow the note to delete the failed/old oracle instance .

How to Remove an Oracle E-Business Suite Release 12 Windows Environment (Metalink Note 567507.1)

More information available on Steven Chan blog – http://blogs.oracle.com/stevenChan/2008/07/new_whitepaper_cleaning_up_app.html “New Whitepaper: Cleaning Up Apps 12 on Windows“

Rename Oracle Table Syntax

alter table table_name rename to new_table_name;

Applications Short Name for most of the Apps Products

Application short names for all product
—————————————————————————
PFT Performance_Analyzer
RMG Risk_Manager
FTP Transfer_Pricing
DNA Development
BLC Utility_Billing
PTX Patch_Tracking_System
EMS Environment_Management_System
RCM Regulatory_Capital_Manager
FND Application_Object_Library
SYSADMIN System_Administration
AU Application_Utilities
AD Applications_DBA
SHT Applications_Shared_Technology
SQLGL General_Ledger
OFA Assets
ALR Alert
RG Application_Report_Generator
CS Service
CCT Telephony_Manager
ECX XML_Gateway
EC e-Commerce_Gateway
ICX Self-Service_Web_Applications
XTR Treasury
AZ Application_Implementation
BIS Applications_BIS
SQLAP Payables
PO Purchasing
CHV Supplier_Scheduling
AR Receivables
PN Property_Manager
QA Quality
CE Cash_Management
FRM Report_Manager
EAA SEM_Exchange
BSC Balanced_Scorecard
ABM Activity_Based_Management
EVM Value_Based_Management
FEM Strategic_Enterprise_Management
PA Projects
AS Sales_Foundation
CN Incentive_Compensation
POM Exchange
OE Order_Entry
WMS Warehouse_Management
turing_Scheduling
INV Inventory
MWA Mobile_Applications
WSM Shop_Floor_Management
FII Financial_Intelligence
OPI Operations_Intelligence
POA Purchasing_Intelligence
HRI Human_Resources_Intelligence
ISC Supply_Chain_Intelligence
AN Sales_Analysis
OKC Contracts_Core
CSC Customer_Care
CSD Depot_Repair
CSF Field_Service
CSS Support
OKS Service_Contracts
ME Controlled_Availability_Product
BIM Marketing_Intelligence
BIC Customer_Intelligence
IES Scripting
AMV Marketing_Encyclopedia_System
AST TeleSales
ASF Sales_Online
CSP Spares_Management
OKX Contracts_Integration
ODQ Data_Query
AMS Marketing
XNM Marketing_for_Communications
XNC Sales_for_Communications
XNS Service_for_Communications
XNP Number_Portability
XDP Provisioning
FPT Banking_Center
IEO Interaction_Center_Technology
GMA Process_Manufacturing_Systems
GMI Process_Manufacturing_Inventory
GMD Process_Manufacturing_Product_Development
GME Process_Manufacturing_Process_Execution
GMP Process_Manufacturing_Process_Planning
GMF Process_Manufacturing_Financials
GML Process_Manufacturing_Logistics
GR Process_Manufacturing_Regulatory_Management
PMI Process_Manufacturing_Intelligence
AX Global_Accounting_Engine
AK Common_Modules-AK
XLA Subledger_Accounting
ONT Order_Management
QP Advanced_Pricing
RLM Release_Management
VEA Automotive
WSH Shipping_Execution
IBA iMarketing
IBE iStore
IBU iSupport
IBY iPayment
IBP Bill_Presentment_&_Payment
BIL Sales_Intelligence
BIX Interaction_Center_Intelligence
IEM Email_Center
OZP Trade_Planning
OZF Trade_Management
OZS iClaims
ASG CRM_Gateway_for_Mobile_Devices
JTF CRM_Foundation
IEX Collections
IEU Universal_Work_Queue
ASO Order_Capture
CSR Scheduler
IEB Interaction_Blending
MFG Manufacturing
BOM Bills_of_Material
ENG Engineering
MRP Master_Scheduling/MRP
CRP Capacity
WIP Work_in_Process
CST Cost_Management
CZ Configurator
RLA Release_Management_Integration_Kit
VEH Automotive_Integration_Kit
PJM Project_Manufacturing
FLM Flow_Manufacturing
MSO Constraint_Based_Optimization
MSC Advanced_Supply_Chain_Planning
RHX Advanced_Planning_Foundation
OKE Project_Contracts
PER Human_Resources
PAY Payroll
FF FastFormula
DT DateTrack
SSP SSP
BEN Advanced_Benefits
HXT Time_and_Labor
HXC Time_and_Labor_Engine
OTA Learning_Management
JA Asia/Pacific_Localizations
JE European_Localizations
JG Regional_Localizations
JL Latin_America_Localizations
GHR US_Federal_Human_Resources
PQH Public_Sector_HR
PQP Public_Sector_Payroll
PSB Public_Sector_Budgeting
GMS Grants_Accounting
PSP Labor_Distribution
IGW Grants_Proposal
IGS Student_Systems
IGF Financial_Aid
IGC Contract_Commitment
PSA Public_Sector_Financials
IPA Capital_Resource_Logistics_-_Projects
CUI Network_Logistics_-_Inventory
CUP Network_Logistics_-_Purchasing
CUF Capital_Resource_Logistics_-_Financials
CUS Network_Logistics
CUN Network_Logistics_-_NATS
CUA Capital_Resource_Logistics_-_Assets
FV Federal_Financials
CUE Billing_Connect
EAM Enterprise_Asset_Management
TE Transportation_Execution
IGI Public_Sector_Financials_International
ITG Internet_Procurement_Enterprise_Connector
MSR Inventory_Optimization
PV Partner_Management
ASL Sales_Offline
POS iSupplier_Portal
AHM Hosting_Manager
ASP Field_Sales/Palm_Devices
BIV Service_Intelligence
CSI Install_Base
CSL Field_Service/Laptop
CUG Citizen_Interaction_Center
IMT iMeeting_(obsolete)
OKI Contracts_Intelligence
IEC Advanced_Outbound_Telephony
CSE Enterprise_Install_Base
OKO Contracts_for_Sales
JTS CRM_Self_Service_Administration
JTM Mobile_Application_Foundation
AHL Complex_Maintenance_Repair_and_Overhaul
OKB Contracts_for_Subscriptions_(obsolete)
IMC Customers_Online
XNI Install_Base_Intelligence
OKR Contracts_for_Rights
IPD Product_Development
ENI Product_Intelligence
BNE Web_Applications_Desktop_Integrator
QRM Risk_Management
PON Sourcing
OKL Lease_Management
IBC Content_Manager
AMF Fulfillment_Services
QOT Quoting
CSM Field_Service/Palm
DOM Document_Managment_and_Collaboration
Advanced_Product_Catalog
DDD CADView-3D
PJI Project_Intelligence
XNB eBusiness_Billing
ZFA Financial_Analyzer
ZSA Sales_Analyzer
CLN Supply_Chain_Trading_Connector_for_RosettaNet
EDR E-Records
PRP Proposals
AMW Internal_Controls_Manager
XLE Legal_Entity_Configurator
ASN Sales
MST Transportation_Planning
FUN Financials_Common_Modules
GCS Global_Consolidation_System
XDO XML_Publisher
ZX E-Business_Tax
LNS Loans
IA iAssets
FPA Portfolio_Analyzer
ZPB Enterprise_Planning_and_Budgeting
———————————————————————————–

Tar and Gunzip utilities for production system (General)

TAR and GUNZIP tools are extremely useful when comes to cloning and backup activities .

• tar cvf – * | gzip > appltop.tar.gz — This command will TAR and gunzip the whole appltop .You can use the command according to your requirements

Tar and gunzip

• tar -cvf file.tar directory — Simple Command for TAR
  

Running AutoConfig(AC) on particular product

My friend asked me how to run the AC on particular product like AD,GL,..etc . Looks like an good option but I didn’t get any hits how to achieve this .

I think there is no explicit parameter in adconfig.pl where we can pass the value of product top.

After some analysis , I found out some option to run AC for particular product and it works too .

For eg. if you want to run for AD (Applications DBA ) alone.

You can pass the particular top driver file parameter to the adconfig.pl . The command looks like this

—-

perl adconfig.pl driver=/d1/V1210/apps/apps_st/appl/ad/12.0.0/admin/driver/adtmpl.drv

We need to change the <PROD>tmpl.drv and I hope it will works for all products.

How to find an AD patchset level ?

SQL> select PATCH_LEVEL from fnd_product_installations where APPLICATION_ID=50;

PATCH_LEVEL
——————————
11i.AD.I

This query works for both 11i and R12 instance

Insight about Archive files for R12

How to create ,replace ,delete and list the archive files in R12

Windows

To list the archive files	e.g. lib /list adst.lib
To include the single object into archive file	e.g. lib adst.lib aimain.obj
To list the particular object	e.g. lib /list adst.lib |grep aimain.obj o/p – aimain.obj
To find the header of particular object	adident Header adst.lib | grep aimain.oc o/p – $Header aimain.oc 120.10 2006/11/28 20:32:39 vlim ship $

Unix

To list the archive files	ar t libad.a ar t libad.a | grep aiures.o
To take out all the files from archive	e.g. ar -xv libad.a
To take out individual file from the archive	e.g. ar -xv libad.a aiures.o
To delete the particular object file from archive	e.g. ar d libad.a aiures.o
To replace or create the particular object file from archive	e.g. ar r libad.a aiures.o

 

 

R12 – Shortcut to access the forms URL and sysadmin Responsibility page

It will be skip the login page and direct to the sysadmin responsibility page. To access the Sysadmin responsibility page http://<host>.<domain>:<PORT >/OA_HTML/fndvald.jsp?username=SYSADMIN&password=SYSADMIN

To Launch the forms directly http://<host>.<domain>:<port>/forms/frmservlet. Modify the context variable parameter (s_appserverid_authentication) from SECURE to OFF and run autoconfig, then forms will startup without that authorization error.

To find the StartCD version – R12

To find the StartCD version for R12

• cd startCD\Disk1\rapidwiz
• Run RapidWizVersion.cmd for Windows /RapidWizVersion for Unix

Example output:

Oracle Applications Rapid Install Wizard
Version 12.0.0.22

(c) Copyright 2000-2006 Oracle Corporation.  All rights reserved.
Press any key to continue . . .

How to find Release version of Oracle Apps?

Table name called FND_PRODUCT_GROUPS. Login to sqlplus as apps/apps

SQL> select release_name from fnd_product_groups;

RELEASE_NAME
————————————————–
12.0.0