My Oracle Support Banner

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***

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 Recommended Cross Reference AWE Indexes:
 FSCM 9.1
 HCM 9.1
 ELM 9.1
 Implementation Instructions:

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