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

Last updated on JULY 12, 2016

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

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 hundreds of Community platforms