Performance Issue During Manifest Picking (Doc ID 2349273.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

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.:

SELECT MMTT.TRANSACTION_SOURCE_ID
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

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.