EGL: How To Query Which Journal Id's Are In An Approver's Worklist (Doc ID 950263.1)

Last updated on MAY 11, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.

***Checked for relevance on 30-MAR-2011***


***Checked for relevance on 26-SEP-2012***


***Checked for relevance on 11-MAY-2017***


Goal

What tables do I need to query in journal approval workflow to find:
-to which approvers' worklist a journal has been submitted for approval
-which journals are currently in an approver's worklist
-the approval status of a journal that has been submitted for approval

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms