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