My Oracle Support Banner

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

Last updated on FEBRUARY 04, 2019

Applies to:

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


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.

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




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

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