Oracle Apps DBA SQL Query To get On Hold Concurrent Request in Oracle Apps R12

Hi All, Please find below the query to identify the HOLD Requests by mapping with the below given tables to get the session and process specific details for the Running Concurrent Requests having Hold. APPS.FND_CONCURRENT_REQUESTS GV$PROCESS GV$SESSION GV$LOCKED_OBJECT GV$LOCK DBA_OBJECTS QUERY TO GET THE HOLDS ON THE CONCURRENT REQUESTS: SELECT FCR.REQUEST_ID, FCR.HOLD_FLAG, GV_SESSION.SERVICE_NAME, GV_SESSION.SQL_TRACE, GV_PROCESS.PROGRAM, […]

Read More

SQL query to find out the concurrent programs attaching to a plsql package

Please find below the query to find Concurrent Programs being attached to a particular PL /SQL Package . The below query can be modified to search Concurrent Program based on addiitonal conditions . Uncomment the condition and pass required parameters to get the desired search results SELECT PROG.CONCURRENT_PROGRAM_ID, PROG.USER_CONCURRENT_PROGRAM_NAME, PROG.CONCURRENT_PROGRAM_NAME , DECODE(EXE.EXECUTION_METHOD_CODE ,  ‘I’, ‘PL/SQL’ […]

Read More

Oracle SQL Query to list all the responsibilities attached to a user in oracle apps

Please find below the Query to  list all the responsibilities attached to a user SELECT FND_USER.USER_NAME,        FND_USER.EMAIL_ADDRESS,        FND_RESP_TL.RESPONSIBILITY_NAME,        FND_USER_RESP_GRP.START_DATE,        FND_USER_RESP_GRP.END_DATE        FROM         FND_USER FND_USER,         FND_USER_RESP_GROUPS_DIRECT FND_USER_RESP_GRP,         FND_RESPONSIBILITY_TL FND_RESP_TL WHERE FND_USER.USER_NAME = :USER_NAME AND FND_USER_RESP_GRP.USER_ID = FND_USER.USER_ID AND FND_USER_RESP_GRP.RESPONSIBILITY_ID = FND_RESP_TL.RESPONSIBILITY_ID AND FND_RESP_TL.LANGUAGE = ‘US’ SQL to get the […]

Read More

Create Request Groups in Oracle Apps for submission of Concurrent Programs

Request group is required to allow submission of concurrent programs or request set from a specific responsibility. First request group is created, then programs/request sets are added to request group. Request group should be assigned to a responsibility from which we want to submit a program. Logon to ‘System Administrator’ responsibility. Go to Security-> Responsibility […]

Read More