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?