Oracle and Open Source Technology Blog
online technical discussion platform
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
Continue readingHi All, 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
Continue readingPlease 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
Continue readingPlease 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
Continue readingRequest 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
Continue readingUser has to be defined in the system to be able to log into oracle applications. Each user should have at least one responsibility assigned and it should not be end dated. User should be not end dated. Log into
Continue reading