My Oracle Support Banner

Creating Trip Stop Using WSH_TRIP_STOPS_PUB.CREATE_UPDATE_STOP API Errors With Weight or Volume UOM Cannot be Cleared if a Value Already Exists (Doc ID 2808446.1)

Last updated on OCTOBER 03, 2023

Applies to:

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

Symptoms

After applying <Patch 32467690>:R12.WSH.C, API WSH_TRIP_STOPS_PUB.CREATE_UPDATE_STOP stopped working.
Trip Stops are not getting created and the following error occurs:


Weight or Volume UOM cannot be cleared if a value already exists.



STEPS

The issue can be reproduced at will with the following steps:

1. Run API WSH_TRIP_STOPS_PUB.CREATE_UPDATE_STOP to create trip stop
2. See error

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.