Enterprise Scheduler Service and Jobs - Oracle Fusion Applications Administration Essentials - page 69

3. Select Database trace , shown as follows:

Once the database trace is enabled, rerun the long-running job. Retrieve the request
ID of the job. The database trace will be identified by its fnd_session_id . The
fnd_session_id can be retrieved from the request_cp table.

For example, let us trace the job with the request ID 2227 . Log in to the Oracle Fu-
sion Database with the fusion_ora_ess schema using the following query:

Sqlplus fusion_ora_ess/password
SQL> select fnd_session_id from REQUEST_CP
where requestid=2227;

The output of the previous command is as follows: