ETL9.1: NEW INDEXES TO IMPROVE PAYABLE TIME AND APPROVAL FRAMEWORK PERFORMANCE (Doc ID 1297206.1)

Last updated on JULY 13, 2016

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

Center of Expertise has identified several indexes which improve the performance of the Time & Labor and  AWE interaction. This only includes indexes for PS_TL..... tables.

This would assist with online (Approve Payable Time page) as well as batch performance (TL_APPRV_AE) related to Payable Time Approvals.

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