Oracle MWA Is Slow "Please Wait" While Using Load and Drop (Doc ID 2258428.1)

Last updated on APRIL 24, 2017

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Performance

ACTUAL BEHAVIOR
---------------
Oracle MWA is slow "Please Wait" --- but only a few times/week. It cannot be reproduced at will

Using the Mobile Device the users are finding "Please Wait...." for a long time. It was tracked from a backend session and found that this query was running and taking long time:

SELECT DISTINCT QT.TASK_ID TASK_NUM, QT.PICK_SLIP, WDT.TASK_TYPE WMS_TASK_TYPE_ID, NVL(WDT.PRIORITY, 0) TASK_PRIORITY, DECODE(:B15 , 2, MOL.HEADER_ID, NULL) BATCH_ID, SUB.PICKING_ORDER SUB_PICKING_ORDER, LOC.PICKING_ORDER LOC_PICKING_ORDER, ((NVL(LOC.X_COORDINATE, 0) - :B14 ) *(NVL(LOC.X_COORDINATE, 0) - :B14 ) + (NVL(LOC.Y_COORDINATE, 0) - :B13 ) *(NVL(LOC.Y_COORDINATE, 0) - :B13 ) + (NVL(LOC.Z_COORDINATE, 0) - :B12 ) *(NVL(LOC.Z_COORDINATE, 0) - :B12 )) DISTANCE, WDT.STATUS TASK_STATUS, QT.TRANSACTION_TYPE_ID, QT.TRANSACTION_ACTION_ID, QT.TRANSACTION_SOURCE_ID, QT.TRANSACTION_SOURCE_TYPE_ID FROM WMS_DISPATCHED_TASKS WDT, (SELECT TRANSACTION_TEMP_ID TASK_ID, PICK_SLIP_NUMBER PICK_SLIP, CARTONIZATION_ID, ORGANIZATION_ID, SUBINVENTORY_CODE, LOCATOR_ID, MOVE_ORDER_LINE_ID, TRANSACTION_TYPE_ID, TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_ID, TRANSACTION_SOURCE_TYPE_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE WMS_TASK_TYPE IS NOT NULL AND TRANSACTION_TEMP_ID = DECODE(:B7 , 'BULK', PARE

The database session for this was in the wait event "gc cr request" frequently even though there were no issues in the RAC cluster.


EXPECTED BEHAVIOR
-----------------------
Expect to have better performance

STEPS
-----------------------
The issue cannot be reproduced at will -- but it was happening during Pick Load and Drop


Cause

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 hundreds of Community platforms