EAP: Poor performance at AP_PAYSELECT.A0016000.Step03, AP_PAYSELECT.A0016000.Step21, and AP_WTHDCALC.PRE_PROC.PRE_CUR2 (Doc ID 1231865.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version: 8.9 to 9.1 - Release: 8.9 to 9
Information in this document applies to any platform.

Symptoms

Poor performance at the following AE steps:

AP_PAYSELECT.A0016000.Step03
AP_PAYSELECT.A0016000.Step21
AP_WTHDCALC.PRE_PROC.PRE_CUR2

All of these steps refer to the view PS_RT_DFLT_VW. which reference the tables PS_RT_INDEX_TBL and PS_RT_RATE_TBL tables.


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