My Oracle Support Banner

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

Last updated on MAY 26, 2023

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.


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.





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

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