2 Replies Latest reply: Oct 24, 2013 1:35 PM by User720740-Oracle RSS

    Delivered PeopleSoft Query

    User720740-Oracle

      I need your help with a GL delivered query.  I am sure if you look at your client environment, the query should be delivered as well.  The delivered query is  called, GL_ARCH_JRNL that archives Journals in GL.

       

      I couldn’t make out from the criteria column what it is doing.  From what I gathered it is archiving Journals that are posted and closed by specifying as prompt values the Business unit and ledger group. ?? I know this query archives Journals which are closed and posted but I wasn’t sure what the other prompt values meant such as Request data, As of Data, Retention days and Begin date…

       

      Please advise if am understanding this correct.

       

       

       

      Please advise.