Purge Aged Cost Component Exceptions (elc_except_purge_job)
|
Module Name |
rtvprg.pc |
|
Description |
Purge Aged Returns to Vendors |
|
Functional Area |
Transfers, Allocations and RTVs |
|
Module Type |
Admin |
|
Module Technology |
ProC |
|
Catalog ID |
RMS320 |
|
Runtime Parameters |
N/A |
|
Wrapper Script |
b8dwrap.ksh |
Design Overview
This background job is composed of two steps processing. It will have a threading assignment and a business logic processing.
In RMFCS, 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:
| 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 component exceptions log table.
Thread assignment program will filter eligible records from cost component exceptions log table based on its purge criteria from defined number of retention months (default to 6 months). These records are chunked and Thread ID is assigned for each. They will be stored temporarily in a staging table.
The Business logic will process all records from the staging table. Using bulk processing, this program will delete the records from cost component exceptions log table. It will free up and clean the staging table afterwards. There is a STOP ON NEXT feature in bulk processing (through a loop) where Administrators can stop this batch with a flip of this indicator.