My Oracle Support Banner

SHIPMENT.NO_OF_BOXES Field Length To Increase To 6 Digits (Doc ID 2779808.1)

Last updated on JUNE 12, 2021

Applies to:

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


Currently SHIPMENT.NO_OF_BOXES can accept only 4 digits and incoming ASNOut.container_qty can accommodate unto 6 digits. Whenever container_qty is a value higher than 9999, incoming message fails with error:

Error: javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_ASNOUT.CONSUME(?,?,?,?)}: [E] Error ORA-06502: PL/SQL: numeric or value error: number precision too large returned by program unit RMSSUB_ASNOUT.PARSE_BOL.

Steps to Reproduce:
1. Send an ASNOut to RMS with ASNOut.container_qty higher than 9999.
2. Notice message is failed in RIB Hospital with error listed above.


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

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