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 later
Oracle Advanced Pricing - Version 12.2 and later
Information in this document applies to any platform.
On : 12.2.5 version, Transaction Booking
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.
Expectation is that the order should be booked.
The issue can be reproduced at will with the following steps:
1. Log into OM responsibility.
2. Query an order.
3. Book the order.
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
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