My Oracle Support Banner

EAP: Update Withholdings Performance Issue at Step AP_WTHD_UPDT.UpdVtmp.Step10 (Doc ID 2637093.1)

Last updated on JULY 20, 2020

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.



Updated 2 Suppliers to Withholding through the Update Supplier Withholdings page. There is a total of 4,532 Vouchers that need to be updated.

When running Update Withholdings, process is failing at Step AP_WTHD_UPDT.UpdVtmp.Step10 with an error due to filling up the tempdb space.  This is causing a performance issue.

Could not allocate space for object 'dbo.SORT temporary run storage: 141625894830080' in database 'tempdb' because the 'PRIMARY ' filegroup is full. Create disk space by deleting unneeded file

1.  Navigate to Suppliers > 1099/Global Withholding > Maintain > Update Supplier Withholdings
2.  Add 2 Supplier IDs that will have at least 4,000 Vouchers combined
3.  Select Y for New Withhold and populate the New Withhold Details as appropriate
4.  Run 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.