My Oracle Support Banner

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

Last updated on FEBRUARY 16, 2018

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.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, Order Entry users are experiencing unacceptable waits when finishing lines and moving to next line.

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.