E-AWE: Recommended Indexes for Application Cross Reference (XREF) Tables to Improve Performance of Approval Workflow Engine (AWE) (Doc ID 1328945.1)

Last updated on JULY 06, 2023

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.1 to 9.1 [Release 9]
PeopleSoft Enterprise HCM eProfile - Version 9.1 to 9.1 [Release 9]
PeopleSoft Enterprise HCM eCompensation Manager Desktop - Version 9.1 to 9.1 [Release 9]
PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.1 [Release 9]
PeopleSoft Enterprise PT PeopleTools - Version 8.49 to 8.51 [Release 8.4]
Information in this document applies to any platform.

Symptoms

The following lists describe the indexes recommended for each Cross Reference (XREF) Table and the Target associated with it. Find the Product, and AWE Process ID, and create the Indexes.

The following example is for the 9.1 Applications, which use Approval Framework (AWE) fields prefaced with 'EOAW'. For the 9.0 Applications, these same AWE fields are prefaced with 'PTAF'.

Each Application released their distinct cross reference tables with one index for the primary AWE keys by default. The default index created for the AWE keys is on these fields:

(EOAWTHREAD_ID, EOAWPRCS_ID)

Besides this basic index, additional indexes are generally needed for specific application transactions as well.