Finding EBS/Oracle Apps Version

Query to find Responsibility for which Menu / Form Function is assigned To get responsibility based on Menu SELECT DISTINCT a.respon...

In the previous post, we have seen an overview about ADOP . Now we will try to understand Various phases of ADOP in detail. Prepare Phase...

We can find the weblogic URL and port from the CONTEXT_FILE by using the below variable. Steps: 1. Go to Application Tier 2. Set the R...

Query to find Form Function attached to which Responsibility Script: SELECT DISTINCT faa.application_name application, rtl.respon...

The below query can be used for getting all the details for a scheduled concurrent program. select a.requested_by,a.status_code,a.phase...

Query to get list of EBS users with responsibility and last login date (responsibility wise) Script: SELECT     usr.user_name,     rsp.respo...

Error: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-6508 Cause: This may be occur while opening forms after clone or if ...

 frmcmp Module=<pll name> Userid=<userid/password> [Parameters].  Optional parameters with default values given: Mo...

Query to find Concurrent Request Details from Concurrent Program Name Script SELECT    distinct user_concurrent_program...

STOP ORACLE RAC 1. emctl stop dbconsole 2. srvctl stop listener -n racnode1 3. srvctl stop database -d RACDB 4. srvctl stop ...