Home > Scripts > Script to find responsibility and request group attached to a conc.program.

Script to find responsibility and request group attached to a conc.program.

October 17, 2011

As a part of troubleshooting we may need to check like to which request group, a specific concurrent program has been assigned. this can be obtained using below script.

 

 

SELECT
FRG.REQUEST_GROUP_NAME,
FRG.DESCRIPTION,
CP.CONCURRENT_PROGRAM_ID,
CP.CONCURRENT_PROGRAM_NAME,
CPT.USER_CONCURRENT_PROGRAM_NAME,
FRV.RESPONSIBILITY_NAME
FROM
FND_REQUEST_GROUPS FRG,
FND_REQUEST_GROUP_UNITS FRGU,
FND_CONCURRENT_PROGRAMS CP,
FND_CONCURRENT_PROGRAMS_TL CPT,
FND_RESPONSIBILITY_VL FRV
WHERE
FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID
AND FRGU.REQUEST_UNIT_ID = CP.CONCURRENT_PROGRAM_ID
AND CP.CONCURRENT_PROGRAM_ID = CPT.CONCURRENT_PROGRAM_ID
AND FRV.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID(+)
AND CPT.USER_CONCURRENT_PROGRAM_NAME LIKE ‘AUD%Missing%Timecar%’
–AND cp.concurrent_program_name = ‘PAXAUMTC’;

Advertisements
Categories: Scripts
%d bloggers like this: