Error In RWMS Hospital : RDMRIB_ERROR.k_SO_IN_DISTRIBUTION_ERROR When A Transfer Is Reviewed (Doc ID 2282762.1)

Last updated on JULY 12, 2017

Applies to:

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

Symptoms

When a transfer is distributed and assigned to a wave in Retail Warehouse Management System(RWMS) and for some reason user goes back to review previous steps,
message to change the transfer status which flows to Retail Merchandising System(RMS), sends the transfer info to the TSF_MFQUEUE table to be published again to RWMS.
When after some seconds user, distributes and assigns again the transfer to a wave in RWMS,
message which flows from RMS to change the transfer status to Approved arrives in RWMS and this message fails in RWMS with the error:

 



Steps to reproduce:

  1. RMS: Create and approve a transfer
  2. RWMS: Check if transfer arrived
  3. RWMS: Distribute and assign the transfer to a wave
  4. RMS: Check if the status of the transfer changed
  5. RWMS: run the ./run_distribution.sh batch
  6. RMS: Check if the status of the transfer changed
  7. RMS: Stop the Transfer publisher (just to simulate the error)
  8. RWMS: Undistribute and unassign the transfer
  9. RWMS: Assign the transfer to a wave (just to change the transfer status)
  10. RMS: Check if the status of the transfer changed
  11. RMS: Check TSF_MFQUEUE table if transfer is ready to be published
  12. RMS: Start the Transfer publisher
  13. RWMS: Check the RIB_MESSAGE. Message should be found with error: "k_SO_IN_DISTRIBUTION_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