My Oracle Support Banner

Performance Issue During Manifest Picking (Doc ID 2349273.1)

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.

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

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.