My Oracle Support Banner

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

Last updated on AUGUST 25, 2022

Applies to:

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


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.




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.