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 OCTOBER 19, 2021
Applies to:
PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
ISSUE:
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.
REPLICATION STEPS:
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
ACTUAL RESULT:
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.
EXPECTED BEHAVIOR:
The delivered DCAP24941462 AE Program should complete in a timely manner according to the amount of transactions being processed.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |