My Oracle Support Banner

E-AWE: Approval Workflow Path Sequence Is Based On The Order Stored In The Database, Does The Order Cause Issues While Processing The Definition Transactions? (Doc ID 2376870.1)

Last updated on MARCH 21, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
PeopleSoft Enterprise SCM eProcurement - Version 9.1 and later
PeopleSoft Enterprise HCM Human Resources - Version 9.1 and later
Information in this document applies to any platform.

Goal

Approval Framework (AWE) Paths appear to be built by database row sequence. A cloned Process Definition where the Paths are exactly the same, except on how they are stored in the database, this SQL output illustrates the opposite order of the Path ID :

 

EFFDT EOAWSTAGE_NBR EOAWPATH_ID
SQL Selected for Cloned Definition from PS_EOAW_PATH
03-JAN-10 0 1
03-JAN-10 10 2
03-JAN-10 10 3
03-JAN-10 10 1
04-JAN-10 0 1
04-JAN-10 10 1
04-JAN-10 10 2
04-JAN-10 10 3

 

 

 

 

 

 

 

 

 

 



Would this behavior be a cause for concern while processing the Definition Transactions?

 

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!


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