My Oracle Support Banner

Shipping Transportation Outbound Interface Error ORA-22814: Attribute or Element Value is Larger Than Specified in Type for Lot Numbers Greater Than 32 Characters (Doc ID 2255913.1)

Last updated on MAY 05, 2023

Applies to:

Oracle Shipping Execution - Version 12.1.3 to 12.2.12 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

When sending deliveries to OTM via Shipping Transportation Outbound Interface, the following error occurs:


ERROR

<errorMessage xmlns="http://xmlns.oracle.com/apps/wsh/outbound/util/WshOtmGlobalOutbound">
Unexpected Error: Error in Routine WSH_OTM_OUTBOUND.GET_DELIVERY_OBJECTS,
Oracle Error - -22814 ORA-22814: attribute or element value is larger than specified in type </errorMessage>



STEPS

1. Order Management Super User Responsibility
2. Order Organizer > Create new sales order and book
3. Shipping > Release Sales Orders where delivery details are pick released and assigned to a delivery.
4. Shipping > Transactions > Query Orders.
5. Specify Lot numbers for the items being shipped. The lot number will have a length greater than 32 characters
6. Run the Shipping Transportation Outbound Interface concurrent request to send deliveries to OTM.
7. Shipping Transportation Outbound Interface ends in error and deliveries are not sent to OTM.
8. XML Transmission shows error in addition to the Parent an Child Requests of the STOI.

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


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