My Oracle Support Banner

ItemTcktCre Message Fails in Error Hospital With "User-Defined Exception [Invalid Message Type]" (Doc ID 1986814.1)

Last updated on AUGUST 17, 2018

Applies to:

Oracle Retail Integration Bus - Version 13.2 to 13.2.7 [Release 13.2]
Oracle Retail Warehouse Management System - Version 13.2 to 13.2.7 [Release 13.2]
Information in this document applies to any platform.


After performing data conversion for DC_ITEM_TICKET table, ItemTcktCre messages were created and inserted into the ITEM_MFQUEUE table.  However, all of these messages went to the error hospital with the following description, found in RWMS RIB_MESSAGE_FAILURE:

javax.ejb.EJBException: Exception while processing request: Error from {call RDMSUB_ITEMS.CONSUME(?,?,?,?,?)}: [E] User-Defined Exception[Invalid Message Type]
at com.retek.rib.binding.subscriber.impl.PlsqlSubscriberCoreServiceImpl.subscribe(
at com.retek.rib.j2ee.RIBMessageSubscriberEjb$MessageHandler$
at com.retek.rib.j2ee.RIBMessageSubscriberEjb$MessageHandler$
at com.retek.rib.j2ee.RIBMessageSubscriberEjb$MessageHandler.handleMessage(
at com.retek.rib.collab.HospitalController.performHandlerCall(
at com.retek.rib.collab.HospitalController.doMessage(
at com.retek.rib.collab.HospitalController.doMessage(
at com.retek.rib.j2ee.RIBMessageSubscriberEjb.onMessage(

RWMS13DEV.RDMRIB_CONSTANTS package has predefined message type constants. There is no ItemTcktCre among them.

Steps to Reproduce:

  1. Fill in dc_item_ticket.dat file with relevant values.
  2. Run dc_load_main.ksh -q dc_load.seq
  3. Check if ITEM_TICKET RMS table has all values from dc_item_ticket.dat
  4. Check if ItemTcktCre messages are created successfully
  5. Check entries in RWMS schema for tables RIB_MESSAGE, RIB_MESSAGE_FAILURE





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.