Tsfprg.pc Does Not Remove Entries From TRANSFERS_PUB_INFO (Doc ID 1946730.1)

Last updated on DECEMBER 21, 2016

Applies to:

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

Symptoms

When a transfer is created in Retail Merchandising System (RMS) and published by the Retail Integration Bus (RIB), and when the transfer is deleted using the RMS GUI and TSFPRG is run the transfer is deleted from TSFHEAD and TSFDETAIL but not from TRANSFERS_PUB_INFO.

Steps to Reproduce:

  1. Create a Store to Store Manual Requisition transfer in RMS. Approve it.
  2. Wait for RIB to publish the transfer. Validate that there are records in TSFHEAD/TSFHDETAIL/TRANSFERS_PUB_INFO for the new transfer and TRANSFERS_PUB_INFO.PUBLISHED=’Y’.
  3. Edit the transfer in RMS and delete it.
  4. Run TSFPRG, including PREPOST TSFPRG PRE.
  5. Query TSFHEAD/TSFHDETAIL/TRANSFERS_PUB_INFO for the edited transfer, note that there are no records in TSFHEAD/TSFHDETAIL but TRANSFERS_PUB_INFO still has a record for the deleted transfer.

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