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.
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.
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:
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