Warehouse Control Board Form Hangs Indefinitely When Querying Inbound Loaded Tasks
(Doc ID 2295065.1)
Last updated on AUGUST 08, 2017
Applies to:Oracle Warehouse Management - Version 12.2.5 and later
Information in this document applies to any platform.
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.
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
The Trace file shows the following SQL
As per the Trace file see the following
Ran the following SQL and noticed there is some Cartesian join ( huge rows returned )
FROM mtl_material_transactions_temp mmtt ,
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 ,
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(+) =
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 = 1884
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',
OR (mtrl.reference IS NULL
AND mtrl.transaction_source_type_id = 5) )
AND mtrl.BACKORDER_DELIVERY_DETAIL_ID IS NULL;
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
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