The blog provides 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, GV_SESSION.MODULE, GV_SESSION.ACTION, […]
FND_CONCURRENT_REQUESTS Status Codes and Phase Code values
We execute very frequently SQL on the table – FND_CONCURRENT_REQUESTS to get the details on the Concurrent details to analysis and know the parameters and other details but not sure if we actually have details on all Status Codes and Phase Codes getting used in the table – FND_CONCURRENT_REQUESTS MEANING FOR THE PHASE_CODE COLUMN VALUES: […]
SQL query to get concurrent programs attach to a plsql package
The below given is 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 additional conditions . Uncomment the condition and pass required parameters to get the desired search results SQL Query: Get concurrent programs attach to a […]
Oracle EBS R12 SQL Query to get all user responsibilities
The below given query provides the list of 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 […]
Assign concurrent programs to Request Group
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. To submit any program we need to associate it with specific responsibility. Identify the request group assigned for that responsibility and then add concurrent program/request […]