add

About Me

My photo
Oracle Apps - Techno Functional consultant

Wednesday, June 13

Concurrent Programs with trace enabled

Shows which programs are defined with Trace enabled. Generally, you should enable trace for a program while you are debugging, but then you should turn it off when you're done.

SELECT A.CONCURRENT_PROGRAM_NAME "Program Name",
SUBSTR(A.USER_CONCURRENT_PROGRAM_NAME,1,40) "User Program Name",
SUBSTR(B.USER_NAME,1,15) "Last Updated By",
SUBSTR(B.DESCRIPTION,1,25) DESCRIPTION
FROM APPS.FND_CONCURRENT_PROGRAMS_VL A, APPLSYS.FND_USER B
WHERE A.ENABLE_TRACE='Y'
AND A.LAST_UPDATED_BY=B.USER_ID;

No comments: