Very Bad Performance When Creating a PO via AutoCreate Despite of Few PR Lines
Last updated on JULY 12, 2016
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:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms