Hi All, Please find below the query to identify the HOLD Requests by mapping with the below given tables to
Category: System Administrator
Meaning of Status Codes and Phase Code in Fnd Conncurent Request table – FND_CONCURRENT_REQUESTS
Hi All, We execute very frequently SQL on the table – FND_CONCURRENT_REQUESTS to get the details on the Concurrent details
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
Oracle SQL Query to list all 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,
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
Oracle Apps – Create user and add responsibility
User has to be defined in the system to be able to log into oracle applications. Each user should have