Interface Trip Stop Performing Poorly added
(Doc ID 1150778.1)
Last updated on FEBRUARY 06, 2019
Applies to:Oracle Shipping Execution - Version 126.96.36.199 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
Interface Trip Stop performance is poor. The following SQL statement is identified as the statement that is poorly performing from the TKPROF trace file:
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document