Interface Trip Stop Performing Poorly added (Doc ID 1150778.1)

Last updated on JULY 26, 2017

Applies to:

Oracle Shipping Execution - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
ConcurrentProgram:WSHINTERFACES - Interface Trip Stop - SRS

Symptoms

Interface Trip Stop performance is poor.  The following SQL statement is identified as the statement that is poorly performing from the TKPROF trace file:

SELECT WDD.DELIVERY_DETAIL_ID
FROM WSH_DELIVERY_DETAILS WDD WHERE WDD.SOURCE_CODE = 'OE' AND
WDD.SOURCE_HEADER_ID = :B2 AND WDD.SOURCE_LINE_ID = :B1 AND
WDD.RELEASED_STATUS <> 'D' AND WDD.DELIVERY_DETAIL_ID IN ( SELECT WDA.DELIVERY_DETAIL_ID FROM WSH_TRIP_STOPS WTS, WSH_DELIVERY_LEGS WDL, WSH_DELIVERY_ASSIGNMENTS WDA
WHERE WTS.BATCH_ID = :B3 AND WTS.STOP_ID = WDL.PICK_UP_STOP_ID AND WDL.DELIVERY_ID = WDA.DELIVERY_ID)
FOR UPDATE NOWAIT

 

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