My Oracle Support Banner

In New SIM Instance, the First Transfers and Returns Created Fail in RIB-RMS With Error: "javax.ejb.EJBException: Exception While Processing Request" (Doc ID 2006658.1)

Last updated on AUGUST 27, 2018

Applies to:

Oracle Retail Store Inventory Management - Version 13.2.6 to 14.1 [Release 13.2 to 14.1]
Information in this document applies to any platform.

Symptoms

In a freshly installed instance of Store Inventory Management (SIM), it is observed that the sequences for transfer and return will have same starting number.  Due to this, whichever message reaches Retail Merchandising System (RMS) via Retail Integration Bus (RIB) second fails with the following error message:

javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_ASNOUT.CONSUME(?,?,?,?)}: [E] This bill of lading (BOL) number already exists for a different From location and To location.; nested exception is: com.retek.rib.binding.exception.RIBIntegrationException: Exception while processing request: Error from {call RMSSUB_ASNOUT.CONSUME(?,?,?,?)}: [E] This bill of lading (BOL) number already exists for a different From location and To location. - Nested exception: - com.retek.rib.collab.RibAPIException: Error from {call RMSSUB_ASNOUT.CONSUME(?,?,?,?)}: [E] This bill of lading (BOL) number already exists for a different From location and To location.


Steps to Reproduce:

  1. Install SIM.
  2. Create a store-to-store transfer, return to vendor (RTV), return to warehouse transactions in SIM.
  3. Notice that the ASNIn message in RMS fails for one of the operations with the reported error, as the Bill of Lading (BOL) number of one transaction matches the BOL number of other transactions.

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.