SOStatus Message Fails in RIB-RMS With Error 'This Detail Record Is Currently in Progress'

(Doc ID 2073668.1)

Last updated on JANUARY 03, 2018

Applies to:

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

Symptoms

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:

Error: 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: ABC;


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 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.

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