TSF Created by the Replenishment are Deleted the Same Day (Doc ID 3030779.1)

Last updated on JUNE 26, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 24.0 and later
Information in this document applies to any platform.

Customer advises that MFCS has been configured to close transfers after a day with the setting WS_AUTO_CLOSE_DAYS = 1.

The batch runs before the purge and takes into account the replenishment transfer which has been created but not yet shipped:

get_vdate >= NVL(sp.ship_date, th1.create_date) + :pi_ws_auto_close_days)

once the transfer is shipped the control is then based on the shipped date instead:

vdate >= ship_date + :pi_ws_auto_close_days

	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

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