My Oracle Support Banner

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.

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.

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
Cause
Solution
References


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