How do you check whether Trace is enabled to particular concurrent program from the back end?

How do you check whether Trace is enabled to particular concurrent program from the back end?
 

Solution:

1. select CONCURRENT_PROGRAM_ID,USER_CONCURRENT_PROGRAM_NAME from apps.fnd_concurrent_programs_tl where USER_CONCURRENT_PROGRAM_NAME like '%Program Name%'; (You will get Id)

2. select concurrent_program_id,enable_trace from apps.fnd_concurrent_programs where concurrent_program_id ='concurrent program id';

===============================

No comments:

Post a Comment