My Oracle Support Banner

EGL9.2: Can PS_SOURCE_TBL Record Be Used in Route Control Type - Edit Table field? (Doc ID 2567144.1)

Last updated on MARCH 02, 2021

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
*** Checked for currency on 01-Mar-2021 ***

Goal

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.

Steps:

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.

Solution

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
Goal
Solution
References


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