Pricing Of Orders Is Very Slow On Large Orders That Are Over 200 Lines
(Doc ID 2827058.1)
Last updated on OCTOBER 12, 2022
Applies to:
Oracle Order Management - Version 12.1.3 and laterOracle Advanced Pricing - Version 12.1.3 and later
Information in this document applies to any platform.
OEXOEORD - Sales order form
Symptoms
On : 12.1.3 version, on orders with more than 200 lines, finds that when one selects Actions and choose Price Orders ,
it takes over 20 minutes to complete.
Expects it to take < 5 minutes based on previous performance.
Versions and Details
--------------------------
Uses the traditional pricing engine.
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
QP_PREQ_GRP QPXGPRES.pls 120.5.12010000.16 SPEC VALID
QP_PREQ_GRP QPXGPREB.pls 120.70.12010000.109 BODY VALID
QP_RESOLVE_INCOMPATABILITY_PVT QPXVINCS.pls 120.1.12010000.1 SPEC VALID
QP_RESOLVE_INCOMPATABILITY_PVT QPXVINCB.pls 120.14.12010000.15 BODY VALID
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User (or equivalent)
2. Navigate to: Orders, Returns > Sales Orders
3. Create a sales order (More than 200 lines)
4. Go to Actions > Price order
Takes a long time, over 20 minutes, to complete the action.
MOST EXPENSIVE QUERIES
1)
Changes
Upgraded to Oracle DB 12C (then this issue started)
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 |
| Changes |
| Cause |
| Solution |
| References |