EAP: Update Withholding Performance Issue At Step AP_WTHD_UPDT.UPDTTRX3.STEP11
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.
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
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