Order Entry Response Time Slow When Entering Lines
(Doc ID 2362338.1)
Last updated on MARCH 01, 2024
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 |