E-AWE: Recommended Indexes for Application Cross Reference (XREF) Tables to Improve Performance of Approval Workflow Engine (AWE)
Last updated on JUNE 26, 2017
Applies to:PeopleSoft Enterprise HRMS Time and Labor - Version 9.1 to 9.1 [Release 9]
PeopleSoft Enterprise SCM Purchasing - Version 9.1 to 9.1 [Release 9]
PeopleSoft Enterprise HRMS eProfile - Version 9.1 to 9.1 [Release 9]
PeopleSoft Enterprise HRMS eCompensation Manager Desktop - Version 9.1 to 9.1 [Release 9]
PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms