My Oracle Support Banner

R12: FV: Performance Issue in Payment Process Request (Doc ID 2798173.1)

Last updated on JULY 25, 2024

Applies to:

Oracle U.S. Federal Financials - Version 12.0.0 and later
Oracle Payables - Version 12.2.9 to 12.2.9 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Experiencing a performance issue in Payment Process Request (PPR) process.

The Format Payment Instruction Program is taking more than 30 minutes to complete.

SQL*Trace / TKPROF shows the longest running SQL is:

 

Steps to reproduce:

  1. Log into Oracle Applications using Payment Manager responsibility.
  2. Open the Payments Manager Home OAF Page
  3. Submit a new Payments Process Request (PPR).
  4. Notice the "Format Payment Instructions" for the PPR takes long time to finish.

 

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.