Close Overdue Transfers (tsfclose)

Module Name

tsfclose.pc

Description

Close Overdue Transfers

Functional Area

Transfers, Allocations and RTVs

Module Type

Admin

Module Technology

ProC

Catalog ID

RMS379

Wrapper Script

rmswrap_multi.ksh

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

This batch program processes unshipped and partially shipped transfers that are considered 'overdue', based on system parameter settings. If this functionality is enabled, then this program will evaluate transfers to determine if they are overdue. The way that a transfer is considered overdue depends on the source and destination locations. There are separate system parameters for each of store to store, store to warehouse, warehouse to store, and warehouse to warehouse types of transfers.

For unshipped transfers, the transfer status is updated to delete and transfer reserved and expected inventory is backed out from the table for the sending and receiving locations respectively. For transfers that are shipped but not fully received, an entry is made into the document close queue table. These transfers are picked up by docclose batch and closed after reconciliation.

Restart/Recovery

The logical unit of work for this module is defined as a unique tsf_no. The restart transfer view is used for threading. This batch program uses table-based restart/recovery. The commit happens in the database when the commit max counter is reached.

Design Assumptions

N/A