Order Entry Response Time Slow When Entering Lines
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms