javax.ejb.EJBException Error Occurs in RIB When a Transfer is Rejected

(Doc ID 1435003.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Store Inventory Management - Version 13.1 to 13.1.6 [Release 13.1]
Information in this document applies to any platform.

Symptoms

When a Transfer is created in one store and rejected during the transfer by another store, a Retail Integration Bus (RIB) failed message is created with the following error:

avax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_SOSTATUS.CONSUME(?,?,?,?)}: [E] Transfer 862 does not exist in RMS. Cannot process deletion of transfer details or decrease of transfer quantities.; nested exception is: com.retek.rib.binding.exception.RIBIntegrationException: Exception while processing request: Error from {call RMSSUB_SOSTATUS.CONSUME(?,?,?,?)}: [E] Transfer 862 does not exist in RMS. Cannot process deletion of transfer details or decrease of transfer quantities. - Nested exception: - com.retek.rib.collab.RibAPIException: Error from {call RMSSUB_SOSTATUS.CONSUME(?,?,?,?)}: [E] Transfer 862 does not exist in RMS. Cannot process deletion of transfer details or decrease of transfer quantities.
com.retek.rib.binding.exception.RIBIntegrationException: Exception while processing request: Error from {call RMSSUB_SOSTATUS.CONSUME(?,?,?,?)}: [E] Transfer 862 does not exist in RMS. Cannot process deletion of transfer details or decrease of transfer quantities. - Nested exception: - com.retek.rib.collab.RibAPIException: Error from {call RMSSUB_SOSTATUS.CONSUME(?,?,?,?)}: [E] Transfer 862 does not exist in RMS. Cannot process deletion of transfer details or decrease of transfer quantities.
at com.retek.rib.binding.subscriber.impl.PlsqlSubscriberCoreServiceImpl.subscribe(PlsqlSubscriberCoreServiceImpl.java:65)
at com.retek.rib.j2ee.RIBMessageSubscriberEjb$MessageHandler.handleMessage(RIBMessageSubscriberEjb.java:357)
at com.retek.rib.collab.HospitalController.performHandlerCall(HospitalController.java:380)


Steps to Reproduce:

  1. Log in to Store Inventory Management (SIM) Store A.
  2. Navigate to "Main Menu" >> "Shipping/Receiving" >> "Transfer" >> "Create Request".
  3. Select a store in "Request To" and enter the item ID.
  4. Click on "Request" button.
  5. Notice that the transfer request is created with Status = "Awaiting Response".
  6. Log in to store B.
  7. Navigate to "Main Menu" >> "Shipping/Receiving" >> "Transfer" and find the transfer request created in step 5.  Double click on it to open the request.
  8. Click "Reject" button.
  9. Check the RIB hospital in the Retail Merchandising System (RMS).
  10. Notice that the corresponding SOStatusCre message fails in RMS.

 

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