Oracle Apps 11i - How to get Trial Balance (GLRTB2) Query?

[rathi]

Hi,
I am working on a Archival project. I am archiving 3 years data from Oracle Apps 11i (GL) to Oracle 10g data base and generating reports in Business objects. I want to generate the existing Summary Trial Balance (GLRTB2) reports in BO. To do that I want to know the query of the existing Summary Trial Balance reports in 11i. From the trace file, I am not able to get clear information about the report.
QA1: Is there any way I can get the direct reports query?
QA2: Is there any ready tool to do the convertion job?
QA3: Do you have any suggestion about our project?

Thanks in advance,
Rathi.

[kapildutt]

In order to get the direct report query you need to open report in report builder otherwise SQL trace on report should give the required information.

http://oracleapps11idba.blogspot.com