Booking Large Orders Causes Performance In Pricing Code
(Doc ID 2679817.1)
Last updated on JULY 08, 2020
Applies to:
Oracle Order Management - Version 12.2 and laterOracle Advanced Pricing - Version 12.2 and later
Information in this document applies to any platform.
Symptoms
On : 12.2.5 version, Transaction Booking
ACTUAL BEHAVIOR
When ever we have an order which is excess of 300 lines per order then the order would never get booked.
Uses traditional pricing engine.
There are 379 line on the order with which we are testing the performance issue.
EXPECTED BEHAVIOR
Expectation is that the order should be booked.
STEPS
The issue can be reproduced at will with the following steps:
1. Log into OM responsibility.
2. Query an order.
3. Book the order.
NOTES
Has applied <Patch 27599458>:R12.QP.C - issue remains.
QP_PREQ_GRP QPXGPRES.pls 120.11.12020000.12 SPEC VALID
QP_PREQ_GRP QPXGPREB.pls 120.132.12020000.107 BODY VALID
Current file versions:
$QP_TOP/patch/115/sql QPXGPREB.pls 120.132.12020000.112
$QP_TOP/patch/115/sql QPXGPRES.pls 120.11.12020000.13
.
EXPENSIVE STATEMENT
Changes
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 |