hello, a very useful small piece of sql, quite useful whilte troubleshootings.

What is the SQL to determine what request groups and concurrent program is assigned to?

select request_group_name from FND_REQUEST_GROUPS where REQUEST_GROUP_ID =(SELECT request_group_id
FROM FND_REQUEST_GROUP_UNITS WHERE REQUEST_UNIT_ID=(select CONCURRENT_PROGRAM_ID from
FND_CONCURRENT_PROGRAMS where CONCURRENT_PROGRAM_NAME ='<report short name>’));

thanks – Shivmohan

5 thoughts

  1. Pingback: Top Referred Articles on KnowOracle | Shivmohan Purohit's Oracle Applications Blog

  2. —-This will work fine:
    select request_group_name from FND_REQUEST_GROUPS where
    REQUEST_GROUP_ID IN(SELECT request_group_id
    FROM FND_REQUEST_GROUP_UNITS WHERE REQUEST_UNIT_ID=(select CONCURRENT_PROGRAM_ID from
    FND_CONCURRENT_PROGRAMS where CONCURRENT_PROGRAM_NAME =’’));

    Like

    Reply

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Google photo

You are commenting using your Google account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s