My Oracle Support Banner

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.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.