Oracle Apps 11i - How to get Trial Balance (GLRTB2) Query?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

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

  1. #1
    Join Date
    Aug 2009
    Posts
    0

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

    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.

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

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