Purge Aged Cost Component Exceptions (elcexcprg)

Module Name

ELCEXCPRG.PC

Description

Purge Aged Cost Component Exceptions

Functional Area

Costing

Module Type

Admin

Module Technology

ProC

Catalog ID

RM S222

Wrapper Script

rmswrap.ksh

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

In Merchandising, you are allowed to make rate changes to cost components, up-charges and expense profiles with future effective dates. Additionally, when these future rate changes are specified, you can choose to cascade these changes to lower levels. The options for how the updates can be cascaded are described in the table below:

Table 3-3 ELCEXCPRG.PC - Cascade Options

Updated Entity Cascade Options

Expense Profiles (Country, Supplier, or Partner)

Order, Item

Cost Component (Expense)

Country, Supplier, Partner, Item, Order

Cost Component (Assessment)

Item, Order

Cost Component (Up-charge)

Department, Item, Transfer/Allocation

Department Level Up-Charges

Item, Transfer/Allocation

When the processes that apply these changes run, they may raise exceptions if the rate for an entity has been overwritten prior to the application of the future rate change. If so, then exceptions are written to the COST_COMP_EXC_LOG table. This program purges the records from this table based on a number of retention months that is passed as a runtime parameter.

Restart/Recovery

N/A

Design Assumptions

N/A