My Oracle Support Banner

Very Bad Performance When Creating a PO via AutoCreate Despite of Few PR Lines (Doc ID 2159922.1)

Last updated on SEPTEMBER 13, 2020

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Purchase Order

Very bad performance when creating a PO via AutoCreate although we just select few(ex, 8~10) PR lines to create a PO.
Select only 8 PR lines but it usually takes about 15~20 minutes to create a PO by AutoCreate.

Reproduce Steps
--------------------
The issue can be reproduced at will with the following steps:
1. Query the PR Lines in AutoCreate form
2. Select few lines(8~10 lines) to create a PO
3. Click the Create button
4. Usually it takes about 15~20 minutes until creating a PO

This performance issue is occurring in the following SQL:

 

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.