My Oracle Support Banner

Performance Issue When Calling Wsh_Deliveries_Pub.Delivery_Action API (Doc ID 2370193.1)

Last updated on MARCH 06, 2018

Applies to:

Oracle Shipping Execution - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Interface Trip Stop

ACTUAL BEHAVIOR
---------------
When calling WSH_Deliveries_Pub.Delivery_Action API to assign delivery to a Trip the performance is not acceptable.


EXPECTED BEHAVIOR
-----------------------
The performance should take seconds rather than several minutes.

STEPS
-----------------------
The issue can be reproduced with the following steps:
 A delivery is assigned to two Trips:
1. Trip 1 - Trip name usually starts with FT. Trip Stops are from Ship From Warehouse to a central location.
2. Trip 2 - Trip is created using Wsh_Trips_Pub.Create_Update_Trip API. Trip Stops are from the above central location to the end destination.
3. While assigning the delivery to Step 2 mentioned above it is taking approximately 4 mins.
4. Once this is complete, call the Wsh_Trips_Pub.Trip_Action API to pick release the Trip.


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!


In this Document
Symptoms
Cause
Solution
References


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