Entries by Oracle ERP Apps Guide

, , , ,

Oracle Apps Log Files Locations in R12

Autoconfig log file: Apps:$INST_TOP/appl/$CONTEXT_NAME/admin/log/$MMDDHHMM/adconfig.log Db:$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/adconfig.log $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/NetServiceHandler.log Startup/Shutdown Log files: $INST_TOP/logs/appl/admin/log Apache, OC4J and OPMN: $LOG_HOME/ora/10.1.3/Apache $LOG_HOME/ora/10.1.3/j2ee $LOG_HOME/ora/10.1.3/opmn Patch log: $APPL_TOP/admin/$SID/log/Workflow Mailer log: $APPLCSF/$APPLLOG/FNDCPGSC*.txt Concurrent log: $INST_TOP/apps/$CONTEXT_NAME/logs/appl/conc/log OAM (Oracle Application Manager) log: $APPLRGF/oam/ Clone log: Preclone log files in source instance Apps:$INST_TOP/apps/$CONTEXT_NAME/admin/log/ (StageAppsTier_MMDDHHMM.log) Db:$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_MMDDHHMM.log) Clone log files in target instance: Apps :$INST_TOP/apps/$CONTEXT_NAME/admin/log/ApplyAppsTier_.log Db:$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_.log – Alert Log File:$ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log Concurrent […]

/by
, , ,

Purge/Delete Completed Concurrent Requests in Apps

Error:Delete/Purge COMPLETED concurrent requests Concurrent request history should not exceed 50K rows, or else it will start impacting on performance SQL> select count(*) from FND_CONCURRENT_PROCESSES; COUNT(*)———- 552 SQL> select count(*) from FND_CONCURRENT_REQUESTS; COUNT(*)———- 85009 ==>>> Should always be below 50K, Else run “Purge Concurrent Request”SQL> SQL> select count(*) from FND_CONCURRENT_REQUESTS 2 where request_date > sysdate-7; […]

/by
, ,

How to View/Access Other User Concurrent Request in Oracle Apps R12

When user OPERATIONS submit a request at System Administratorresponsibility, this user can see the log and output files of this request. But the other user (ex: SYSADMIN) cannot do that even has the same responsibility. If we use the View All Concurrent Requests (System Administrator Mode) form, we only can see the request but not the output file of this request. […]

/by
, , , ,

R12 – How to Find XML Publisher Version

Method One: MetaInfo.class The version of a specific Java Class has a one to one relationship with the currently installed version of Oracle XML Publisher. /home/applprod >strings $OA_JAVA/oracle/apps/xdo/common/MetaInfo.class|grep -i ‘XML Publisher’ Oracle XML Publisher 5.6.3 /home/applprod > Version 5.6.3 ships with update pack 12.1.3, which is Patch 8919491 “Patch R12.ATG_PF.B.delta.3: Oracle Applications Technology 12.1.3 Product Family […]

/by