TSFPRG Throws NO_TSFHEAD_PUB/"Cannot Find Transfer Head For Transfer No Being Published:..." Error (Doc ID 2939738.1)

Last updated on APRIL 04, 2023

Applies to:

Symptoms

The TSFPRG (Transfer Purge) batch generates TransferDtlDel messages in the TSF_MFQUEUE table that gets in error in RMS Error Hospital (EH).

Error
-----------------------
Error Key: NO_TSFHEAD_PUB
Error Description: "Cannot find transfer head for transfer no being published: transfer no %s1. "


Steps to Reproduce
-----------------------

1. Go to rtkstrt-> Inventory -> Transfer.
2. Create a new transfer.
3. Submit and approve the same.
4. Go to the front screen again and open the transfer in EDIT mode.
5. Click on Options -> Delete.
6. Now run the TSFPRG batch.
7. Check the TSF_MFQUEUE table. It retains an entry for the transfer with a message type as TsfDtlDel. The pub_status of the record goes to the EH.
8. A RIB error occurs with the message "Cannot find transfer head for transfer no being published: transfer no %s1. "

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.