Sales Order Booking Activity Performance Issues (Doc ID 2692239.1)

Last updated on JULY 18, 2020

Applies to:

Symptoms

On : 12.2.4 version, Transaction Entry

ACTUAL BEHAVIOR
---------------
Customer is experiencing performance issue during Booking activity

expensive query occurring at

SQL ID: 6tym1a8u3tdgk Plan Hash: NNNNNNN

SELECT NVL(BE1.HIGH_QUANTITY,0), NVL(BE1.LOW_QUANTITY,0)
FROM
 BOM_EXPLOSIONS BE1 WHERE BE1.TOP_BILL_SEQUENCE_ID = :B3 AND
  BE1.COMPONENT_CODE = :B1 AND BE1.EFFECTIVITY_DATE <= :B2 AND
  BE1.DISABLE_DATE > :B2 AND BE1.EXPLOSION_TYPE = 'OPTIONAL' AND
  BE1.PLAN_LEVEL >= 0


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 246 0.07 0.13 0 0 0 0
Fetch 246 653.96 671.33 0 63758772 0 246
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 494 654.04 671.46 0 63758772 0 246

 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1.Responsibility : Oracle Order Management
2.Navigate to Order Return
3.Enter Order
4.Book



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot efficiently book orders

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.