R12: AP: Invoice Validation Takes Long Time to Complete or Hangs When Trying to Validate 600K+ Invoices.
(Doc ID 2763384.1)
Last updated on SEPTEMBER 03, 2024
Applies to:
Oracle Payables - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
Invoice validation takes long time to complete.
Invoice Validation hangs trying to process more than 600K invoices.
The process is running since 30 hrs.
The validation is running with 8 child processes and it takes very time to complete.
An AWR shows the following SQL as outstanding By Elapsed Time and by CPU Time
SQL ID | SQL Module | SQL Text | ||||||||||||||
adj796q5rqv7m | e:SQLAP:cp:sqlap/WORKERAPPRVL |
STEPS TO REPRODUCE:
Changes
Cause
In this Document
|