Installations/Configurations-Applications

Compiling Objects Manually Through SQL Commands First find the Invalid Objects in the Database by below given query. SELECT COUNT(*) FROM DBA_OBJECTS WHERE STATUS = ‘INVALID’; For a more detailed …

Step 1. Setup the profile value at user level with the following value Profile name: “Initialization SQL Statement – Custom” User: [%User Name from which Concurrent program Runs%] Profile value: …

HOW to Verify and Change oc4jadmin Password   Step 1. Run the below command as applmgr user to verify oc4jadmin Password: $ java -jar $IAS_ORACLE_HOME/j2ee/home/jazn.jar -checkpasswd jazn.com oc4jadmin -pw ***** …

General Ledger Interface Tables GL_BUDGET_INTERFACE GL_DAILY_RATES_INTERFACE GL_DRM_HIERARCHY_INTERFACE  GL_DRM_SEGVALUES_INTERFACE GL_IMP_COA_ERR_INTERFACE GL_IMP_COA_NORM_HIER_INTERFACE GL_IMP_COA_SEG_VAL_INTERFACE GL_IEA_INTERFACE GL_INTERFACE GL_INTERFACE_CONTROL GL_INTERFACE_HISTORY GL_REPORT_INTERFACE GL_XFR_INTERFACE   Account Payables (AP) Interface Tables AP_INTERFACE_CONTROLS AP_INTERFACE_REJECTIONS AP_INVOICE_INTERFACE AP_INVOICE_LINES_INTERFACE OIE_POL_RATES_INTERFACE   Account …

  Oracle EBS Application R12 Short Keys   Function Key Function Key Actions LOV Shift + Ctrl + F8 Help Ctrl + H Block Menu Ctrl + B Insert Record …

Tkprof – Convert Trace .trc to Readable    tkprof <file.trc> <file.tkprof> explain=<apps_user>/<pswd> Where,  tkprof: is command <file.trc>: is file name of trace file with location (if currently not in same directory) <file.tkprof>: is …

ERROR   FRM-92050 failed to connect to Server /forms/servlet -1

How to Create a Read-Only APPS Schema?   We are going to create a schema similar to the APPS schema having only read-only privileges.   Step 1. Create the user for the …