Oracle Apps 11i - How to get Trial Balance (GLRTB2) Query?
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,
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.
Click Here to Expand Forum to Full Width