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!


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