2 Replies Latest reply on Oct 24, 2013 6:35 PM by User720740-Oracle

    Delivered PeopleSoft Query


      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.