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

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.

Cause

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 hundreds of Community platforms