Reports are run as concurrent programs in Oracle Apps.
Beginning rel 11.x that becomes easy to activate database trace for a single report. You just need to check trace option box in
concurrent program definition (under System Administrator responsability).
If trace option is not available or you report is customized you can insert an 'alter session set sql_trace=TRUE' in it to activate database trace.
Principle is to :
- make a copy of your report
- generate a .rex file from .rdf (by command r25convm or r25conv32, see respectively Note:1070541.6 and Note:1020489.102)
- edit the .rex file and insert the line immediately after ('FND SRWINIT'); : srw.do_sql('alter session set sql_trace=TRUE');
- insert another line immediately after ('FND SRWEXIT'); to stop tracing : srw.do_sql('alter session set sql_trace=FALSE');
- regenerate the .rdf file
There exist also profile options to activate trace when particular concurrent programs are running.
For instance you can set these profile options below at user level :
INV: Debug Trace
MRP: Trace Mode
OE: Debug Trace
...