ASNInMod Message Throws "RMSSUB_ASNIN.CONSUME(?,?,?,?)}: [E] Error ORA-02292: ... " Error (Doc ID 2228943.1)

Last updated on JULY 21, 2017

Applies to:

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

Symptoms

When trying to update the existing ASNIn the following is the error collected from the RIB_MESSAGE_FAILURE table.


Error
-----------------------

"javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_ASNIN.CONSUME(?,?,?,?)}: [E] Error ORA-02292: integrity constraint (RMSUSER.SSKL_SHS_FK) violated - child record found returned by program unit ASN_SQL.MATCH_SHIPMENT.
at com.retek.rib.j2ee.RIBMessageSubscriberEjb$MessageHandler.handleMessage(RIBMessageSubscriberEjb.java:406)
at com.retek.rib.collab.HospitalController.performHandlerCall(HospitalController.java:382)
at com.retek.rib.collab.HospitalController.doMessage(HospitalController.java:288)
at com.retek.rib.collab.HospitalController.doMessage(HospitalController.java:190)
at com.retek.rib.j2ee.RIBMessageSubscriberEjb.onMessage(RIBMessageSubscriberEjb.java:224)
at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:451)
at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:375)
at weblogic.ejb.container.internal.JMSMessagePoller.processOneMessage(JMSMessagePoller.java:267)
at weblogic.ejb.container.internal.JMSMessagePoller.pollContinuously(JMSMessagePoller.java:330)
at weblogic.ejb.container.internal.JMSMessagePoller.pollForParent(JMSMessagePoller.java:457)
at weblogic.ejb.container.internal.JMSMessagePoller.run(JMSMessagePoller.java:473)
at java.lang.Thread.run(Thread.java:809)
Caused by: com.retek.rib.binding.exception.RIBIntegrationException: Exception while processing request: Error from {call RMSSUB_ASNIN.CONSUME(?,?,?,?)}: [E] Error ORA-02292: integrity constraint (RMSUSER.SSKL_SHS_FK) violated - child record found returned by program unit ASN_SQL.MATCH_SHIPMENT. - Nested exception: - com.retek.rib.collab.RibAPIException: Error from {call RMSSUB_ASNIN.CONSUME(?,?,?,?)}: [E] Error ORA-02292: integrity constraint (RMSUSER.SSKL_SHS_FK) violated - child record found returned by program unit ASN_SQL.MATCH_SHIPMENT.
at com.retek.rib.binding.sub"

 


Steps to Reproduce
-----------------------
The issue can be reproduced at will with the following steps:
1. Load ASNInCre message.
2. Then load the ASNInMod Message and notice the error.



Changes

 

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