Himanshu Sinha - Oracle Apps DBA , Oracle DBA, Oracle Cloud DBA , Enterprise Architect.

Concurrent Request Status Codes: SELECT LOOKUP_CODE STATUS_CODE, MEANING   FROM FND_LOOKUP_VALUES   WHERE LOOKUP_TYPE = 'CP_STATUS_CODE'    AND ENABLED_FLAG = 'Y'    AND VIEW_APPLICATION_ID = 0 ORDER BY LOOKUP_CODE; STATUS_CODE MEANING A Waiting B Resuming C Normal D Cancelled E Error G Warning H On Hold I  Normal M No Manager P Scheduled Q Standby R   Normal S Suspended T Terminating U Disabled W Paused X Terminated Z  Waiting Concurrent Request Phase Codes: SELECT LOOKUP_CODE PHASE_CODE, MEANING   FROM FND_LOOKUP_VALUES   WHERE LOOKUP_TYPE = 'CP_PHASE_CODE'    AND ENABLED_FLAG = 'Y'    AND VIEW_APPLICATION_ID = 0 ORDER BY P...

Register Custom Application In Oracle Applications  As a standard practice when ever you need to write custom code/forms/reports in Oracle Applications you must put then under custom application TOP. This is to avoid impact of patching on custom objects. If we put custom object under stand TOP it might create issue and after patching it may start malfunctioning. If we have all custom code at one place it easy to maintain as we know exactly how many custom objects we have and where they are. Before staring you need to first decide what should be your application name and short name. Here we go .... SCHEMA NAME     : C_APPS TOP NAME        : C_APPS_TOP Application     : Custom Application Data Group      : Standard Request Group   : Custom Request Group #1 – Create directory under application top Login to Application Server and Source the environment variable. ...