EGL9.2: Can PS_SOURCE_TBL Record Be Used in Route Control Type - Edit Table field?
(Doc ID 2567144.1)
Last updated on FEBRUARY 03, 2022
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
There is a requirement to route necessary approvals to source option. Can PS_SOURCE_TBL record be used in Route Control Type - Edit Table field?
Under Route Control Type, when Edit Table field is populated with PS_SOURCE_TBL record, user cannot define a range of values based on Journal Source in Route Control Profile.
1. Navigate to PeopleTools > Workflow > Routings & Roles > Route Control Types.
For Route Control Type, use Edit Table = SOURCE_TBL for Journal Source.
2. Then, in Route Control Profile, define the range based on Journal Source.
However, nothing shows up.
3. Using SQL tool, query from PS_SOURCE_TBL record shows valid rows.
Replication document attached.
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