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
know-oracle.com 
—-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 =’’));
LikeLike
This query throughs an error ORA-01427
LikeLike
This query doesn’t work.
LikeLike
Thank you for this thorough and useful explanation
LikeLike