reports builder 6i incomplete trace

From: <>
Date: Tue, 16 Sep 2008 04:03:05 -0700 (PDT)
Message-ID: <>


1. EBS
2. Report builder 6i
3. Database oracle 9i (9.2.0)

For a report by enabling trace via (tools -> trace -> option trace_all ticked)

I get following output

LOG :       Report: XXXXX_WHCUSTINV_NEW0509

      Logged onto server:


LOG :       Logged onto server: testdb

      Username: xxx


                        | Report Builder Profiler statistics |


             TOTAL ELAPSED Time: 4285726.29 seconds

            Reports Time: 4285725.29 seconds ( 0.00% of TOTAL)

                    ORACLE Time:       1.00 seconds ( 0.00% of TOTAL)

                            UPI:       0.00 seconds

                            SQL:       1.00 seconds

 TOTAL CPU Time used by process: N/A

Where as I was expecting that it will give a detail trace containing SQLs as well as application level timings

This is a long report taking almost 4 mts & i want to find the timing of each sql as well as formula during run time,

Please help me to give some pointers regarding the solutions/ problem.

Thanks in advace.

Shikhar Received on Tue Sep 16 2008 - 06:03:05 CDT

Original text of this message