My Oracle Support Banner

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 later
Information 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:

  1. Log into Oracle Applications using a Payables responsibility.
  2. Open the Standard Request Submission (SRS) screen
    (N) Other > Requests > Run
  3. Submit the "Invoice Validation" concurrent request.  Set parameters accordingly to process more than 100K invoices.
  4. The request spawns its child processes "Invoice Validation Child Worker Process", per the parallel processing settings.
  5. The main and child requests "hang" or take 30+ hours to complete.

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


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