Purge Aged Invoices (invprg)

Module Name

Invprg.pc

Description

Purge Aged Invoices

Functional Area

Invoice Matching

Module Type

Admin

Module Technology

ProC

Catalog ID

RMS253

Wrapper Script

rmswrap.ksh

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

This program will purge old posted invoices that have not already been purged by ordprg.pc (which purges invoices associated with an order). This includes all types of invoices-non-merchandise, credit notes, credit note requests, debit memos, and consignment invoices. Regular merchandise invoices will primarily be deleted through the order purge batch (ordprg.pc) but will be deleted by invprg.pc if they still exist in the system. The invoices considered are those older than the number of months defined in the purge_config_options.ORDER_HISTORY_MONTHS column. The age of the invoices will be determined from the match date; if there is no match date, the invoice date will be used.

Note:

This program deletes only from the Merchandising invoice tables preceded with ‘INVC'.

Restart/Recovery

N/A

Design Assumptions

N/A