Order Picking Performance Issue In R12.2 (Doc ID 2963378.1)

Last updated on AUGUST 22, 2023

Applies to:

Symptoms

Order Picking Performance issue in R12.2

During Sales order picking via MSCA screen, there is a significant delay in processing. 

Issue confirmed in TKPROF Trace as seen below:

SQL ID: 0xuj8y16a2ccp Plan Hash: 1419988215

SELECT DECODE(OOL.ORDER_SOURCE_ID, 10, :B5 , :B4 )
FROM
WSH_DELIVERY_DETAILS WDDC, WSH_DELIVERY_DETAILS WDDP,
WSH_DELIVERY_ASSIGNMENTS WDA, OE_ORDER_LINES_ALL OOL WHERE
WDDC.ORGANIZATION_ID=:B3 AND WDDC.INVENTORY_ITEM_ID=:B2 AND
WDDC.SOURCE_CODE = 'OE' AND WDDP.DELIVERY_DETAIL_ID=
WDA.PARENT_DELIVERY_DETAIL_ID AND WDDP.LPN_ID=:B1 AND WDDC.SOURCE_LINE_ID=
OOL.LINE_ID AND ROWNUM=1


call count cpu elapsed disk query current
rows
------- ------ -------- ---------- ---------- ---------- ----------
----------
Parse 2 0.00 0.00 0 0 0
0
Execute 22 0.02 0.03 0 0 2
0
Fetch 22 99.53 188.04 499374 20526506 0
12
------- ------ -------- ---------- ---------- ---------- ----------
----------
total 46 99.56 188.07 499374 20526506 2
12

STEPS

======

1. Login to Mobile applications
2. Select Material & Mfg responsibility
3. Navigate to Pick/ship > Pick Confirm
4. Choose organization
5. Enter sales order number and select query

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.