DMS Error When Shipping Trailer Having Container With Cube > 100000000.

(Doc ID 2307559.1)

Last updated on OCTOBER 08, 2017

Applies to:

Oracle Retail Warehouse Management System - Version 15.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to ship the container whose cube > 100000000, the following error occurs.

 

Steps To Recreate:

1. Have a container with a cube >= 100000000.
2. Ship a trailer with the previous container.
3.Database Management System(DMS) error is encountered.

Entries from ERROR_LOG table:

FACILITY_ID ERROR_CODE USER_ID ERROR_TS ERROR_SOURCE ERROR_LOC ERROR_MSG
AK -1438 PAR3214 17-AUG-17 HH_SHIP_TRAILER_S Ship_Trailer ORA-01438: value larger than specified precision allowed for this column.ORA-06512: at "WMS01.LOG_ASN_OUT", line 468
AK -1438 PAR3214 17-AUG-17 log_asn_out log_outbound_asn ORA-01438: value larger than specified precision allowed for this column
AK -1438 PAR3214 17-AUG-17 log_asn_out log_asn_out ORA-01438: value larger than specified precision allowed for this column
AK -1438 PAR3214 17-AUG-17 log_asn_out insert_distro_details ORA-01438: value larger than specified precision allowed for this column
AK -1438 PAR3214 17-AUG-17 log_asn_out insert_container_details ORA-01438: value larger than specified precision allowed for this column

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms