Oracle® Retail Merchandising System Operations Guide, Volume 1 - Batch Overviews and Designs 16.0.024 E89599-02 |
|
Previous |
Next |
Suppliers often change the cost of items.
Cost is an important factor in individual transactions and many financial calculations in RMS. Changes in cost must be reflected in the information stored in RMS and pending transactions.
The following batch designs are included in this functional area:
sccext.pc (Supplier Cost Change Extract)
ccprg.pc (Cost Change Purge)
Module Name | sccext.pc |
Description | Apply Pending Cost Changes to Items |
Functional Area | Cost Change |
Module Type | Business Processing |
Module Technology | ProC |
Catalog ID | RMS355 |
Runtime Parameters | NA |
The sccext module selects supplier cost change records that are set to go into effect the next day and updates the RMS item/supplier/country tables with the new cost. The item/location tables are also updated with the new cost if the cost change impacts the primary supplier/country for an item/location, as this is considered a base cost change. The process also triggers a recalculation of cost and deal application for pending purchase orders.
The logical unit of work for the program is a cost change. The program is also restartable from the last successfully processed cost change record.
Table 9-2 Key Tables Affected
Table | Select | Insert | Update | Delete |
---|---|---|---|---|
COST_SUSP_SUP_HEAD |
Yes |
No |
No |
No |
DEAL_CALC_QUEUE_TEMP |
Yes |
No |
No |
No |
DEAL_CALC_QUEUE |
Yes |
Yes |
Yes |
No |
PERIOD |
Yes |
No |
No |
No |
ITEM_SUPP_COUNTRY_LOC |
Yes |
No |
Yes |
No |
COST_SUSP_SUP_DETAIL |
Yes |
No |
No |
No |
DEAL_SKU_TEMP |
No |
Yes |
No |
No |
PRICE_HIST |
No |
Yes |
No |
No |
ITEM_SUPPLIER |
Yes |
No |
Yes |
No |
SUPS |
Yes |
No |
No |
No |
SYSTEM_OPTIONS |
Yes |
No |
No |
No |
COST_SUSP_SUP_DETAIL_LOC |
Yes |
No |
No |
No |
ITEM_SUPP_COUNTRY |
Yes |
No |
Yes |
No |
ITEM_SUPP_COUNTRY_BRACKET_COST |
Yes |
Yes |
Yes |
No |
ITEM_MASTER |
Yes |
No |
No |
No |
PACKITEM |
Yes |
No |
No |
No |
Module Name | ccprg.pc |
Description | Purge Aged Cost Changes |
Functional Area | Cost Change |
Module Type | Admin |
Module Technology | ProC |
Catalog ID | RMS476 |
Runtime Parameters | NA |
This program is responsible for removing old cost changes from the system. Cost changes are removed from the system using the following criteria:
The status of the cost change is Delete, Canceled, or Extracted.
The status of the price change is Rejected and the effective date of the cost change has met the requirement for the number of days that rejected cost changes are held.
The number of days that rejected cost changes are held is determined by the system parameter Retention of Rejected Cost Changes (RETENTION_OF_REJECTED_COST_CHG).