1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Identifying Unposted Journals in Oracle General Ledger

Discussion in 'Oracle Apps Technical' started by prashantrais, Sep 25, 2010.

  1. prashantrais

    prashantrais Active Member

    Likes Received:
    Trophy Points:
    Here is the code to identify Unposted Journals in General Ledger, these journals are from gl_interface

    Code (SQL):
    SELECT          user_je_source_name,
                      accounting_date, COUNT(accounting_date),
                      SUM(accounted_dr), SUM(accounted_cr)
    FROM   gl_interface
    GROUP BY user_je_source_name, accounting_date
    ORDER BY accounting_date, user_je_source_name;