EAP: Update Withholding Performance Issue At Step AP_WTHD_UPDT.UPDTTRX3.STEP11 (Doc ID 2230319.1)

Last updated on FEBRUARY 03, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

The Update Withholdings process uses the VCHRL_WTH_TMP temp table where there is NO data in the table at the start of the Application Engine process.  Within the AP_WTHD_UPDT process, thousands of rows are added to the table.  But, because the Update Statistics request (in AP_WTHD_UPDT.BeginUpd.Step07) is within a loop and the process is restartable, a commit cannot be executed.  This commit is required for the Update Statistics to take place,  but the Update Statistics request is ignored. This is causing a performance problem issue with Step AP_WTHD_UPDT.UpdtTrx3.Step11.

STEPS:
1. Make Withholding Adjustments: Suppliers > 1099/Global Withholding >
Maintain > Update VoucherLine Withholding
2. Suppliers > 1099/Global Withholding > Maintain > Update Withholdings

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