Performance Issue During Manifest Picking
Last updated on JANUARY 16, 2018
Applies to:Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.
In Oracle warehouse Management, Users are facing performance issue in order number LOV for manifest picking after applying Patch 19510621:R12.WMS.B
The Mobile Telnet Applications gives "please wait" message and hangs just after choosing one order and click done in manifest picking in WMS
The Trace file Shows the following expensive SQL
The most time was on full scan reading for the two MTL_SALES_ORDERS and MTL_MATERIAL_TRANSACTIONS_TEMP.
The query that read full scan for the table as the following below. There is no join between two tables.:
FROM MTL_SALES_ORDERS MSO , MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
WHERE MMTT.TRANSACTION_SOURCE_ID IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_ORDER_IDS)) )
AND QT.PARENT_LINE_ID IS NULL )
OR ('B7' = 'MANIFESTPICKSLIP' AND QT.PICK_SLIP IN (SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_PICK_SLIP_NUMBERS)) AND QT.PARENT_LINE_ID IS NULL
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms