My Oracle Support Banner

R12 AP: Scheduled Payment Selection Report ( APINVSEL ) in PPRs Has Performance Issues (Doc ID 1605839.1)

Last updated on OCTOBER 21, 2024

Applies to:

Oracle Payables - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

The "Scheduled Payment Selection Report" (APINVSEL) has a performance issue.

The report is running anywhere between 4hrs and 10hrs for 30k+ invoices.  In addition, report output still does not show invoices that got picked.

 

The SQL statement that is taking long time is the following:

 

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. Find/Select concurrent program "Scheduled Payment Selection Report", enter parameters and Submit.
  4. Concurrent takes long to complete, sometimes up to 10 hrs to process 30K+ invoices.

 

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.