Oracle® Retail Item Planning User Guide for the RPAS Classic Client Release 14.1 E55314-01 |
|
Previous |
The Data Validation workbook contains all measures that are either loaded or touched during the batch calculation process. This template is used by the administrator only to verify the results of data loads and batch processes.
The Data Load Validation workbook contains the following tabs:
To build a Data Load Validation workbook, perform the following steps:
Click the New icon in the toolbar.
The New Workbook dialog box appears. On the Item Planning Administration tab, select Data Validation and click OK.
The Data Validation Wizard appears at the Select Calendar step. Select the weeks you want to validate and click Next.
The Select Product step appears. Select the products you want to validate and click Next.
The Select Location step appears. Select the channels you want to validate and click Finish.
The Data Load Validation workbook is built.
Use the Item Planning Measures worksheet to validate that the Item Planning data was updated in the batch process.
Table 8-1 lists the measures available on this worksheet.
Table 8-1 Item Planning Measures Worksheet Measures
Measure | Description |
---|---|
Wp BOP Inv C |
Working Plan Beginning of Period Inventory Cost. |
Wp BOP Inv R |
Working Plan Beginning of Period Inventory Retail. |
Wp BOP Inv U |
Working Plan Beginning of Period Inventory Units. |
Wp EOP Inv C |
Working Plan End of Period Inventory Cost. |
Wp EOP Inv R |
Working Plan End of Period Inventory Retail. |
Wp EOP Inv U |
Working Plan End of Period Inventory Units. |
Wp MD Allowance R |
Working Plan Markdown Allowances Retail. |
Wp On Order C |
Working Plan On Order Cost. |
Wp On Order R |
Working Plan On Order Retail. |
Wp On Order U |
Working Plan On Order Units. |
Wp Receipts C |
Working Plan Receipts Cost. |
Wp Receipts R |
Working Plan Receipts Retail. |
Wp Receipts U |
Working Plan Receipts Units. |
Wp Sls Clr C |
Working Plan Clearance Sales Cost. |
Wp Sls Clr R |
Working Plan Clearance Sales Retail. |
Wp Sls Clr U |
Working Plan Clearance Sales Units. |
Wp Sls Promo C |
Working Plan Promotional Sales Cost. |
Wp Sls Promo R |
Working Plan Promotional Sales Retail. |
Wp Sls Promo U |
Working Plan Promotional Sales Units. |
Wp Sls Reg C |
Working Plan Regular Sales Cost. |
Wp Sls Reg R |
Working Plan Regular Sales Retail. |
Wp Sls Reg U |
Working Plan Regular Sales Units. |
Use the MFP Measures worksheet to validate that the MFP data was updated in the batch process.
Table 8-2 lists the measures available on this worksheet.
Table 8-2 MFP Measures Worksheet Measures
Measure | Description |
---|---|
MFP Cp BOP Inv C |
MFP Current Plan Beginning of Period Inventory Cost. |
MFP Cp BOP Inv R |
MFP Current Plan Beginning of Period Inventory Retail. |
MFP Cp BOP Inv U |
MFP Current Plan Beginning of Period Inventory Units. |
MFP Cp COGS C |
MFP Current Plan Cost of Goods Sold Cost. |
MFP Cp EOP Inv C |
MFP Current Plan End of Period Inventory Cost. |
MFP Cp EOP Inv R |
MFP Current Plan End of Period Inventory Retail. |
MFP Cp EOP Inv U |
MFP Current Plan End of Period Inventory Units. |
MFP Cp GPM |
MFP Current Plan Gross Margin. |
MFP Cp MD Clr R |
MFP Current Plan Clearance Markdowns Retail. |
MFP Cp MD Perm R |
MFP Current Plan Permanent Markdowns Retail. |
MFP Cp MD Promo R |
MFP Current Plan Promotional Markdowns Retail. |
MFP Cp MD R |
MFP Current Plan Total Markdowns (Clearance + Promotional + Regular) Retail. |
MFP Cp Receipts C |
MFP Current Plan Receipts Cost. |
MFP Cp Receipts R |
MFP Current Plan Receipts Retail. |
MFP Cp Receipts U |
MFP Current Plan Receipts Units. |
MFP Cp Ttl Sls C |
MFP Current Plan Total Sales Cost. |
MFP Cp Sls Clr C |
MFP Current Plan Clearance Sales Cost. |
MFP Cp Sls Clr R |
MFP Current Plan Clearance Sales Retail. |
MFP Cp Sls Clr U |
MFP Current Plan Clearance Sales Units. |
MFP Cp Sales Net VAT R |
MFP Current Plan Sales Net Value Added Tax Retail. |
MFP Cp Sls Promo C |
MFP Current Plan Promotional Sales Cost. |
MFP Cp Sls Promo R |
MFP Current Plan Promotional Sales Retail. |
MFP Cp Sls Promo U |
MFP Current Plan Promotional Sales Units. |
MFP Cp Ttl Sls R |
MFP Current Plan Total Sales Retail. |
MFP Cp Sls Reg C |
MFP Current Plan Regular Sales Cost. |
MFP Cp Sls Reg R |
MFP Current Plan Regular Sales Retail. |
MFP Cp Sls Reg U |
MFP Current Plan Regular Sales Units. |
MFP Cp Ttl Sls U |
MFP Current Plan Total Sales Units. |
MFP Op BOP Inv C |
MFP Original Plan Beginning of Period Inventory Cost. |
MFP Op BOP Inv R |
MFP Original Plan Beginning of Period Inventory Retail. |
MFP Op BOP Inv U |
MFP Original Plan Beginning of Period Inventory Units. |
MFP Op COGS C |
MFP Original Plan Cost of Goods Sold Cost. |
MFP Op EOP Inv C |
MFP Original Plan End of Period Inventory Cost. |
MFP Op EOP Inv R |
MFP Original Plan End of Period Inventory Retail. |
MFP Op EOP Inv U |
MFP Original Plan End of Period Inventory Units. |
MFP Op GM |
MFP Original Plan Gross Margin. |
MFP Op MD Clr R |
MFP Original Plan Clearance Markdowns Retail. |
MFP Op MD Perm R |
MFP Original Plan Permanent Markdowns Retail. |
MFP Op MD Promo R |
MFP Original Plan Promotional Markdowns Retail. |
MFP Op MD R |
MFP Original Plan Total Markdowns (Clearance + Promotional + Regular) Retail. |
MFP Op Receipts C |
MFP Original Plan Receipts Cost. |
MFP Op Receipts R |
MFP Original Plan Receipts Retail. |
MFP Op Receipts U |
MFP Original Plan Receipts Units. |
MFP Op Ttl Sls C |
MFP Original Plan Total Sales Cost. |
MFP Op Sls Clr C |
MFP Original Plan Clearance Sales Cost. |
MFP Op Sls Clr R |
MFP Original Plan Clearance Sales Retail. |
MFP Op Sls Clr U |
MFP Original Plan Clearance Sales Units. |
MFP Op Sales Net VAT R |
MFP Original Plan Sales Net Value Added Tax Retail. |
MFP Op Sls Promo C |
MFP Original Plan Promotional Sales Cost. |
MFP Op Sls Promo R |
MFP Original Plan Promotional Sales Retail. |
MFP Op Sls Promo U |
MFP Original Plan Promotional Sales Units. |
MFP Op Ttl Sls R |
MFP Original Plan Total Sales Retail. |
MFP Op Sls Reg C |
MFP Original Plan Regular Sales Cost. |
MFP Op Sls Reg R |
MFP Original Plan Regular Sales Retail. |
MFP Op Sls Reg U |
MFP Original Plan Regular Sales Units. |
MFP Op Ttl Sls U |
MFP Original Plan Total Sales Units. |
Use the Default Measures worksheet to validate that the default measure data was updated in the batch process.
Table 8-3 lists the measures available on this worksheet.
Table 8-3 Default Measures Worksheet Measures
Measure | Description |
---|---|
DR Ty EOP Clr C |
Default Role Used for Loading Measures This Year End of Period Clearance Inventory Cost. |
DR Ty EOP Clr R |
Default Role Used for Loading Measures This Year End of Period Clearance Inventory Retail. |
DR Ty EOP Clr U |
Default Role Used for Loading Measures This Year End of Period Clearance Inventory Units. |
DR Ty EOP Reg C |
Default Role Used for Loading Measures This Year End of Period Regular Inventory Cost. |
DR Ty EOP Reg R |
Default Role Used for Loading Measures This Year End of Period Regular Inventory Retail. |
DR Ty EOP Reg U |
Default Role Used for Loading Measures This Year End of Period Regular Inventory Units. |
DR Ty On Order C |
Default Role Used for Loading Measures This Year On Order Cost. |
DR Ty MD Allowance R |
Default Role Used for Loading Measures This Year Markdown Allowances Retail. |
DR Ty On Order R |
Default Role Used for Loading Measures This Year On Order Retail. |
DR Ty On Order U |
Default Role Used for Loading Measures This Year On Order Units. |
DR Ty Receipts C |
Default Role Used for Loading Measures This Year Receipts Cost. |
DR Ty Receipts R |
Default Role Used for Loading Measures This Year Receipts Retail. |
DR Ty Receipts U |
Default Role Used for Loading Measures This Year Receipts Units. |
DR Ty Sls Clr C |
Default Role Used for Loading Measures This Year Clearance Sales Cost. |
DR Ty Sls Clr R |
Default Role Used for Loading Measures This Year Clearance Sales Retail. |
DR Ty Sls Clr U |
Default Role Used for Loading Measures This Year Clearance Sales Units. |
DR Ty Sls Promo C |
Default Role Used for Loading Measures This Year Promotional Sales Cost. |
DR Ty Sls Promo R |
Default Role Used for Loading Measures This Year Promotional Sales Retail. |
DR Ty Sls Promo U |
Default Role Used for Loading Measures This Year Promotional Sales Units. |
DR Ty Sls Reg C |
Default Role Used for Loading Measures This Year Regular Sales Cost. |
DR Ty Sls Reg R |
Default Role Used for Loading Measures This Year Regular Sales Retail. |
DR Ty Sls Reg U |
Default Role Used for Loading Measures This Year Regular Sales Units. |
Use the Assortment Planning Measures worksheet to validate that the Assortment Planning data was updated in the batch process.
Table 8-4 lists the measures available on this worksheet.
Table 8-4 Assortment Planning Measures
Measure | Description |
---|---|
Ap Cp BOP Inv Cost |
Assortment Planning Current Plan Beginning of Period Inventory Cost. |
Ap Cp BOP Inv Retail |
Assortment Planning Current Plan Beginning of Period Inventory Retail. |
Ap Cp BOP Inv Units |
Assortment Planning Current Plan Beginning of Period Inventory Units. |
Product Cost |
The cost of the product. |
Ap Cp EOP Inv Cost |
End of Period Inventory Cost. |
AP Cp EopPerStr U% |
Assortment Planning Current Plan EOP Per Store Unit %. |
Ap Cp EOP Inv Retail |
Assortment Planning Current Plan End of Period Inventory Retail. |
Ap Cp EOP Inv Units |
Assortment Planning Current Plan End of Period Inventory Units. |
Exit Date |
Date that inventory should be removed from sales floor. |
AP Cp Gross Margin |
Assortment Planning Current Plan Gross Margin. |
AP Cp GP R% |
Assortment Planning Current Plan Gross Profit Retail %. |
Ap Cp Clearance Markdown Retail |
Assortment Planning Current Plan Clearance Markdowns - Price reduction used to clear aged or slow moving inventory at Retail. |
Ap Cp First Markdown % Off |
Assortment Planning Current Plan Initial Markdown Taken expressed as a rate. |
Ap Cp Perm Markdown Retail |
Permanent Markdowns representing a permanent retail decrease to the owned inventory price of merchandise for strategic downward re-pricing decisions at Retail. |
Ap Cp Promo Markdown Retail |
Promotional Markdowns representing the temporary reduction to the owned inventory price for promotional purposes expressed at Retail. |
Pack Size |
Quantity of style / color or styles purchased from Supplier as a pack. |
Ap Cp Clearance Price Change % |
Assortment Planning Current Plan Clearance Price Change %. |
Ap Cp Clearance Price Retail |
Assortment Planning Current Plan Clearance Price Retail. |
Ap Cp Perm Price Change % |
Permanent Price Change expressed as a rate. |
Ap Cp Product Original Ticket Price |
Initial retail of product. |
Ap Cp Promo Price Change % |
Assortment Planning Current Plan Promotional Price Change %. |
Ap Cp Promo Price Retail |
Promotional Price Average Unit Retail. |
Ap Cp Perm Price Retail |
Average Unit Retail resulting from a Permanent Price Change. |
AP Cp Receipts AUC |
Assortment Planning Current Plan Receipts Average Unit Cost. |
AP Cp Receipts AUR |
Assortment Planning Current Plan Receipts Average Unit Retail. |
Ap Cp Receipts Cost |
Assortment Planning Current Plan Receipts Cost. |
AP Cp Average Recpts Per Str |
Assortment Planning Current Plan Average Receipts per store. |
Ap Cp Receipts Retail |
Assortment Planning Current Plan Receipts Retail. |
Ap Cp Receipts Units |
Receipts expressed as Units. |
AP Cp Receipts U% |
Assortment Planning Current Plan Receipts Units rate. |
Ap Cp Ttl Sls AUC |
Assortment Planning Current Plan Total Sales Average Unit Cost. |
Ap Cp Ttl Sls AUR |
Assortment Planning Current Plan Total Sales Average Unit Retail. |
Ap Cp Ttl Sls C |
Assortment Planning Current Plan Total Sales Cost. |
Ap Cp Sls Clr AUC |
Assortment Planning Current Plan Clearance Sales Average Unit Cost. |
Ap Cp Sls Clr AUR |
Assortment Planning Current Plan Clearance Sales Average Unit Retail. |
Ap Cp Clearance Sales Cost |
Assortment Planning Current Plan Clearance Sales Cost. |
Ap Cp Clearance Sales Retail |
Assortment Planning Current Plan Clearance Sales Retail. |
Ap Cp Clearance Sales Units |
See Clearance Sell Thru %. |
AP Cp Avg Sls Per Str U |
Assortment Planning Current Plan Average Sales per store represented in units. |
Ap Cp Ttl Sls R |
Assortment Planning Current Plan Total Sales Retail. |
Ap Cp Sls Reg AUC |
Assortment Planning Current Plan Regular Sales Average Unit Cost. |
Ap Cp Sls Reg AUR |
Assortment Planning Current Plan Regular Sales Average Unit Retail. |
Regular Sales Cost |
Assortment Planning Current Plan Regular Sales Cost. |
Regular Sales Retail |
Assortment Planning Current Plan Regular Sales Retail. |
Regular Sales Units |
Assortment Planning Current Plan Regular Sales Units. |
Start Sales Date |
The date the product is expected to start selling. |
Ap Cp Ttl Sls U |
Assortment Planning Current Plan Total Sales Units. |
Sell Thru % |
Assortment Planning Current Plan Sell Thru representing the percent of total available Inventory sold in a period of time Change %. |
Store Count |
Count of Stores. |
Number of weeks at Clearance Price |
Number of weeks the item is expected to sell at Clearance Price. |
Number of Weeks at Regular Price |
Number of weeks the item is expected to sell at Regular Price. |