Performance Issue When Calling Wsh_Deliveries_Pub.Delivery_Action API
(Doc ID 2370193.1)
Last updated on JULY 19, 2021
Applies to:
Oracle Shipping Execution - Version 12.1.3 and laterInformation 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.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |