My Oracle Support Banner

Shipment Detail Rest API call fails with ORA-22814 Error (Doc ID 2758277.1)

Last updated on JULY 25, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.0 and later
Information in this document applies to any platform.

Symptoms

Shipment Detail rest API call fails with the below error.

Error ORA-22814: attribute or element value is larger than specified in type returned by program unit REST_SHIPMENT_SVC.SHIPMENT_DETAIL.

Steps to reproduce:
-------------------
1. Pick a shipment that has a carton value that is greater than 20 characters in length.
2. Make a shipment detail rest API call. Pass distro number, distro type as input parameters.
3. Note it fails with the above 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.