DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009

    Question 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,

  2. #2
    Join Date
    Feb 2001
    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.