Purge Aged Mass Return Transfers and RTV (mrtprg)

Module Name

mrtprg.pc

Description

Purge Aged Mass Return Transfers and RTVs

Functional Area

Transfers, Allocations and RTVs

Module Type

Admin

Module Technology

ProC

Catalog ID

RMS274

Wrapper Script

rmswrap_multi.ksh

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

The purpose of this module is to purge mass return transfer (MRT) records, and their associated transfers and RTVs. Only MRTs with a status of closed in which all transfers associated with the MRT are also closed and where the time elapsed between the current date and the close date is at least equal to the system parameter value for MRT Transfer Retention days.

Restart/Recovery

The logical unit of work for this batch program is a warehouse location. The program is multithreaded using restart all locations view.

Design Assumptions

N/A