My Oracle Support Banner

R12:AP:Format Payment Instructions With Text Output is having Performance (Doc ID 2433165.1)

Last updated on AUGUST 08, 2018

Applies to:

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

Symptoms

On : 12.2.5 version,

Format Payment Instructions with Text Output is having Performance Issues

Problems when running concurrent request "Format Payment Instructions with Text Output" for 20000 invoices.

SQL_id 82s6zq96f6v1g is tacking much of the time.

 

ERROR
-----------------------
Performance problems


STEPS
-----------------------


1. Using Payables Manager responsibility

2. Navigate to Other > Requests

3. Click on Single Request

4. Enter Request Name (Format Payment Instructions with Text Output)

5. Enter Parameters

6. Click Ok

7. Click on Submit



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users facing performance problems when running Format Payment Instructions with Text Output

NOTE: THIS SOLUTION IS ONLY VALID IF CUSTOMER HAS DB VERSION 12.

 

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
 Standard Patching Process
 Patch Wizard
 Enhancement Requests
 Have more questions?
References


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