EAP 9.2: Slow Performance Detected At Step DCAP24941462.MAIN.Step02 For Accounts Payable Voucher Withholding Data Conversion
(Doc ID 2553551.1)
Last updated on JULY 30, 2020
Applies to:PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Performing a systems upgrade to PeopleSoft Enterprise FSCM 9.2 Application Release. During the tasks of Data Conversion, the technical team detected a significant performance degradation when running the delivered DCAP24941462 AE Program (To udpate VCHR_LINE_WTHD table).
The offending SQL Statement is contained within Step DCAP24941462.MAIN.Step02.
1.- Upgrade a PeopleSoft FSCM environment to Version 9.2
2.- Via Change Assistant, follow the Data Conversion tasks, and run delivered DCAP24941462 AE Program
3.- Confirm that after hours of processing, the program has yet to complete
The delivered DCAP24941462 AE Program is taking between 30 to 45 hours to complete. This affects the upgrade project, which may come to a halt, and thus causing additional costs to the company.
The delivered DCAP24941462 AE Program should complete in a timely manner according to the amount of transactions being processed.
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