Warehouse Control Board Form Hangs Indefinitely When Querying Inbound Loaded Tasks (Doc ID 2295065.1)

Last updated on SEPTEMBER 06, 2021

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
When attempting to query Inbound Loaded Tasks on the WMS Control board, the form gets hangs completely.
There is no search result obtained here. The user session had to be killed to continue further.

EXPECTED BEHAVIOR
-----------------------
Expect the system to show the results or say no tasks available. The form should not hang indefinitely.

The Trace file shows the following SQL which runs forever

=====================

Ran the following SQL and noticed  there is some Cartesian join ( huge rows returned )

SELECT count(*)
FROM mtl_material_transactions_temp mmtt ,
wms_op_operation_instances wooi,
wms_dispatched_tasks wdt ,
mtl_system_items_vl msiv ,
mtl_item_locations_kfv milv ,
wms_license_plate_numbers wlpn5 ,
wms_license_plate_numbers wlpn4 ,
bom_standard_operations bso ,
mtl_item_locations_kfv milv1 ,
wms_op_plans_vl wop ,
per_all_people_f pap ,
mtl_txn_request_headers mtrh ,
mtl_txn_request_lines mtrl
WHERE 1 =1
AND mmtt.transaction_temp_id = wooi.source_task_id (+)
AND mmtt.organization_id = msiv.organization_id
AND mmtt.inventory_item_id = msiv.inventory_item_id
AND mmtt.organization_id = milv.organization_id(+)
AND mmtt.locator_id = milv.inventory_location_id(+)
AND milv1.organization_id(+) =
NVL(mmtt.transfer_organization,mmtt.organization_id)
AND mmtt.transfer_subinventory = milv1.subinventory_code(+)
AND mmtt.transfer_to_location = milv1.inventory_location_id(+)
AND mmtt.lpn_id = wlpn5.lpn_id(+)
AND mmtt.transfer_lpn_id = wlpn4.lpn_id(+)
AND mmtt.standard_operation_id = bso.standard_operation_id(+)
AND mmtt.organization_id = bso.organization_id(+)
AND mmtt.operation_plan_id = wop.operation_plan_id(+)
AND mmtt.organization_id = xxxx
AND mtrh.header_id = mtrl.header_id
AND mtrh.move_order_type = 6
AND mmtt.move_order_line_id = mtrl.line_id
AND ( mtrl.reference IN ('PO_LINE_LOCATION_ID',
'ORDER_LINE_ID', 'SHIPMENT_LINE_ID')
OR (mtrl.reference IS NULL
AND mtrl.transaction_source_type_id = 5) )
AND mtrl.BACKORDER_DELIVERY_DETAIL_ID IS NULL;

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login as Warehouse Manager
2. Navigate Inquiry > Warehouse Control Board.
3. Enter Source = Inbound, Status = Loaded
4. Click Find.

The form hangs indefinitely

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.