My Oracle Support Banner

Order Entry Response Time Slow When Entering Lines (Doc ID 2362338.1)

Last updated on FEBRUARY 17, 2019

Applies to:

Oracle Order Management - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Oracle Advanced Pricing - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Transaction Entry

ACTUAL BEHAVIOR
---------------
Unacceptable performance during the creation of Sales Orders on Production.
Personalizations have been removed but the low performance remains.
Issue is replicable on a recent Clone of Production.

The most expensive SQLs are related to Pricing (QP) tables.

UPDATE QP_PREQ_QUAL_TMP SET PRICING_STATUS_CODE = :B4
WHERE UNIQUE_KEY = :B1 AND PRICING_STATUS_CODE = :B3 AND PRICING_PHASE_ID = :B2

SELECT /*+ ORDERED NO_EXPAND USE_NL(qpq qplatq qph)  index (qplatq,QP_PREQ_LINE_ATTRS_TMP_N6)
     index(qpq qp_qualifiers_n1) index(qph qp_list_headers_b_n7) l_mini_outer_qual_cur_mod */
QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG,
QPQ.SEARCH_IND, :B9 VALIDATED_FLAG, :B9 APPLIED_FLAG, :B10 ATTRIBUTE_LEVEL, :B4 ATTRIBUTE_TYPE, QPLATQ.CONTEXT ,
QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO ,


EXPECTED BEHAVIOR
-----------------------
Order entry should have better performance.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Connect to Applications using an Order Management Responsibility
2. Open the Sales Order Form.
3. Create the Order Header
4. Go To Lines Tab.
5. Create the Order Lines.
  ==> Bad performance while creating the Order Lines.


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
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.