Purge Aged Competitive Pricing Data (cmpprg.pc)

Module Name

cmpprg.pc

Description

Purge Aged Competitive Pricing Data

Functional Area

Competitive Pricing

Module Type

Admin

Module Technology

ProC

Catalog ID

RMS198

Wrapper Script

rmswrap.ksh

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

This program deletes from the competitive price history table and the competitive shopping list table based purge criteria based on system parameter settings. The Competitive Pricing Months parameter will determine how many months competitive price history should be maintained before deletion. The Competitive Pricing List Days parameter will determine how long a requested shopping list should remain on the shopping list table if it is not complete by the requested shop date.

Restart/Recovery

N/A

Design Assumptions

N/A