My Oracle Support Banner

Transfer Purge Messages Stuck In RIB Due To Inconsistent Design For Purge Transfer (Doc ID 2727872.1)

Last updated on NOVEMBER 24, 2020

Applies to:

Oracle Retail Store Inventory Management - Version 14.1.3 and later
Information in this document applies to any platform.

Symptoms

 SIM Batch Modules

Running tsfprg.pc in RMS 14 sends Stockorder delete messages sent from RMS14 to SIM14, the messages  get stuck in SIM14 queue as they have already been purged from SIM14 using purge_data_pkg.delete_received_transfers.SIM14 Transfer purge has already been implemented and running for some time. As a result, SIM14 and RMS 14 Purge are on different intervals - systems allow this and business requirements for purge criteria are different for each:


As SIM14 and RMS14 are having independent purge processes, Transfer information across these systems is not matching. Due to this, messages for Transfers purged in RMS14 are failing in SIM14 – unable to process them in SIM14 as Transfer doesn’t exist in SIM14.


ERROR
-----------------------
Stock return
does not exist for distro number: 6051590940
at
oracle.retail.sim.server.integration.consumer.stockorder.StockOrderRemoveConsu
mer.buildReturnDoesNotExistException(Unknown Source)
at
oracle.retail.sim.server.integration.consumer.stockorder.StockOrderRemoveConsu
mer.handleReturn(Unknown Source)
at
oracle.retail.sim.server.integration.consumer.stockorder.StockOrderRemoveConsu
mer.handleMessage(Unknown Source)
at
oracle.retail.sim.server.integration.consumer.stockorder.StockOrderRemoveConsu
mer.handleMessage(Unknown Source)
at
oracle.retail.sim.server.integration.consumer.SimMessageConsumerFactory.consum
e(Unknown Source)

Steps to reproduce:

  1. Data to be purged from SIM. Transfer in status 40 - received
  2. The same transfer in RMS with status closed
  3. First run PurgeReceivedTransfers.sh batch from SIM
  4. Run docclose batch from RMS
    ./docclose $UP

  5. Verify DOC_PURGE_QUEUE table in RMS
    select * from DOC_PURGE_QUEUE

  6.  Run tsfprg batch from RMS$ ./prepost $UP tsfprg pre
    $ ./tsfprg $UP
    $ ./prepost $UP tsfprg post
  7.  Verify MPS_STAGED_MESSAGE table in SIM and see the error

Changes

 

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