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.
On : 12.1.3 version, Transaction Entry
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
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 ,
Order entry should have better performance.
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.
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.
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