Retail Integration Bus (RIB) Messages Of Many Families Fail, Returning "ORA-01438" Error

(Doc ID 370070.1)

Last updated on JANUARY 23, 2018

Applies to:

Oracle Retail Integration Bus - Version 10.3 to 11.2 [Release 10 to 11]
Information in this document applies to any platform.
Checked for relevance on 03-September-2010
Checked for relevance 07-Mar-2012


A Retail Integration Bus (RIB) message comes to Retail Data Management (RDM), and the consume call returns an error.


2006.05.09 15:52:36.189||HospitalController.checkFlaggedForInsertion()...Message had error:
java.sql.SQLException: OracleObjectSubscriberHelper.execute() threw Exception: Error from {call
RDMSUB_ITEMS.CONSUME(?,?,?,?,?)}: [E] User-Defined

The message does not get inserted into the error hospital, because of a secondary error.

Secondary Error:

HospitalController had a problem inserted error into error hospital:java.sql.SQLException:
ORA-01438: value larger than specified precision allows for this column.


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