My Oracle Support Banner

javax.ejb.EJBException Error Occurs in RIB When a Transfer is Rejected (Doc ID 1435003.1)

Last updated on JULY 17, 2018

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

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
Symptoms
Cause
Solution
References


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