My Oracle Support Banner

EGL9.2:Can PS_JRNL_AF_XREF or Any Other Record Be Used As Validation to Compare OPRID that Created and Submitted Journal for Approval, Thereafter to Route Transaction for Approval When Found to be Different? (Doc ID 2828373.1)

Last updated on DECEMBER 15, 2021

Applies to:

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


Site is looking to possibly use the PS_JRNL_AF_XREF record in the Workflow Approval Framework criteria as it seems to be the only place in the process to see what OPRID submitted the journal, stored it would seem in the ORIGINATORID and the EOAWREQUESTOR_ID fields.

The requirement is to identify this condition and route based upon as OPRID that created the journal could subsequently be identified as an approver and allowed to approve.

Customer would like to compare OPRID that created GL JE to OPRID that submitted the GL JE and use the result in GL JE configuration to route transaction for approval when found to be different.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.