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 MAY 10, 2021
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.
***Checked for currency on 06-May-2021***
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:
Besides this basic index, additional indexes are generally needed for specific application transactions as well.
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
|Recommended Cross Reference AWE Indexes:|