My Oracle Support Banner

SOStatus Message Fails in RIB-RMS With Error 'This Detail Record Is Currently in Progress' (Doc ID 2073668.1)

Last updated on MAY 28, 2021

Applies to:

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


A SOStatusCre (Stock order Status Create) message from Store Inventory Management (SIM) fails in RIB-RMS when an item is deleted from a store to store transfer:


javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_SOSTATUS.CONSUME(?,?,?,?)}: [E] This detail record is currently in progress and cannot be deleted from the transfer. tsf_no: XYZ, item: XXX;

Steps to Reproduce (sample scenario):

  1. Create a Store to Store transfer in SIM for 2 items with 5 quantity each.
  2. For the first item, update the quantity to 2 in SIM and click on Done button. 
  3. Notice in Retail Merchandising System(RMS) TSFDETAIL table that tsf_qty updates to 2 and cancelled_qty updates to 3.
  4. Now, delete the same item in SIM.
  5. In RIB-RMS, the SOStatus message fails with above error.




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.