Mirror of Oracle documentation
Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.
A
Appendix: Glossary of Measures
This appendix describes the measures.
| Measure Name | Description |
|---|---|
| # of Perf Groups | Number of performance groups used to create clusters (1–5). |
| # of Space Groups | Number of space groups used to create clusters (1–5). |
| Admin Item Store Exception | Displays system-generated item-store exclusions derived from attribute-level exception rules. |
| Admin Lead Time (Weeks) | Defines the number of weeks between order placement and receipt arrival, determining when receipts must be scheduled to meet demand. |
| Admin Min Order Qty U | Defines the minimum order quantity based on supplier requirements. |
| Admin Order Frequency (Weeks) | Defines the cadence of deliveries. For example, a value of 2 represents every other week, and 4 represents every four weeks. |
| Admin Pres Min U | Defines the minimum presentation quantity required at the store level to maintain adequate product display. |
| Admin Prod Attribute Store Exception | Displays administrator-defined attribute-level store exclusions. |
| Admin Product Attr Store Exception | Boolean measure used to define product attribute–store exceptions. A value of true indicates that items with the selected attribute value are excluded from the assortment for the specified location. |
| Admin Safety Stock (Weeks) | Defines the number of weeks of demand that should be maintained as safety stock. |
| AF Cp Avg ROS U | Assortment Fit Current Plan average rate of sale units. |
| AF Cp GM % | Assortment Fit Current Plan gross margin percentage. |
| AF Cp Sales R, U | Assortment Fit Current Plan sales retail, units. |
| AF Cp Week End | Assortment Fit Current Plan end week. |
| AF Cp Week Start | Assortment Fit Current Plan start week. |
| Allow Export | Boolean measure used to indicate whether a position is included in plan data exports. A value of true includes the position in the export. |
| Approve | Boolean measure that flags the curve library for approval. The Approve application action is executed after selecting this trigger measure. |
| Approve Assortment | Boolean measure that enables execution of the Approve Assortment application action to finalize the assortment. |
| Approve To | Drop-down measure used to select the version where clusters will be saved. Existing versions can be overwritten. |
| Approved Cluster | Displays the names of approved cluster versions. |
| Approved Sales Curve % | Displays the approved sales curve used in Item Planning. |
| Assign Cluster | Drop-down measure used to select an approved cluster version. |
| Assigned Assort Period | Assortment Period assignment to the calendar hierarchy. |
| Assigned Cluster | Displays the cluster assignment for each location by assortment period. |
| Avg Sales U | Average sales units across locations (visible at aggregate levels). |
| Avg Space U | Average space units for the space group. |
| Batch Uses RDX | When the Boolean is checked, it enables batch process to import Hierarchy and Measures data from AIF using RDX instead of direct file-based imports. |
June 16, 2026 Appendix A-1 of A-9
Appendix A
| Measure Name | Description |
|---|---|
| Bell Curve % | Defines the percentage distribution of demand across weeks using a bell- shaped pattern. |
| Channel | Channel associated with the location. |
| Class - Product Attribute Eligibility | Controls which attribute types are assigned to a product category (class). Enabled attributes are available to planners within Assortment Planning displays. |
| Cluster | Final cluster assignment based on selected inputs and overrides. |
| Cluster Source 1, 2, 3 | Drop-down measures used to select location attributes for clustering. At least one selection is required. |
| Cluster Version | Cluster version to be used for planning the Assortment Period |
| Comments | Optional field used to capture notes related to the cluster version for downstream reference. |
| Country/Region | Geographic classification of the location. |
| Cp Approved Comment | Detailed approval comments stored in the Current Plan from previous approvals. |
| Cp GM %, R | Current Plan gross margin percentage and retail. |
| Cp Option Assorted | Current Plan assortment selection indicating items included in the approved assortment. |
| Cp Option Assorted Count | Number of items included in the Current Plan assortment. |
| Cp Sales R, U | Current plan sales retail and units. |
| Cp Store Count | Defines the number of stores for each style-color in the approved plan. |
| Cp Week End | Defines current plan end week. |
| Cp Week Start | Defines current plan start week. |
| Curve Description | User-defined label used to identify the curve for specific business use cases. |
| Curve Duration | Displays the number of weeks represented in the curve. |
| Curve Source (Year) | Defines the year used to source data for seeding the curve. |
| Curve Type | Drop-down measure used to select the curve type. Absolute retains the original weekly distribution and normalizes to 100%. Relative resizes the curve to match the assortment period and normalizes to 100%. |
| Define Label | User-defined name for the assortment period used for identification in planning wizards. |
| Define Version Label | Optional field used to assign a descriptive name to the cluster version for easier identification. |
| Duration (Weeks) | Number of weeks in the assortment period. |
| Enable Daily Exports | When the Boolean is checked, it indicates that planned data should be exported daily. |
| Enable MFP CS Integration | When the Boolean is checked, it indicates that MFP CS Integration is enabled. |
| Enable RMF CS Integration | When the Boolean is checked, it enables the execution of additional batch processes required to integrate items with RMF CS. |
| Enable Weekly Exports | When the Boolean is checked, it indicates that planned data should be exported weekly. |
| End Week | Last week of the assortment period, derived from Start Date and Duration. |
| Export Elapsed Periods | When the Boolean is checked, it indicates that elapsed periods should be exported. |
| Fcst Avg ROS U | Forecast average rate of sale units. |
| Fcst Sales U | Forecast sales units. |
June 16, 2026 Appendix A-2 of A-9
Appendix A
| Measure Name | Description |
|---|---|
| Generate Assortment Fit | Boolean measure that enables execution of the Generate Assortment Fit application action to generate assortment recommendations. |
| Gross Margin Weight R | Percentage weight assigned to gross margin retail for the selected clustering strategy. Used in calculating the combined scoring index for location clustering. |
| Gross Margin Weight R % | Percentage weight assigned to gross margin rate for the selected clustering strategy. Used in calculating the combined scoring index for location clustering. |
| Image | Visual representation of the style-color, which may include product images or CAD drawings from the visual library. |
| Item Id | Identifier assigned within APCS to represent a placeholder at the SKU (style- color-size) level. |
| Item Image Name | The file name of the image associated with the style-color item. |
| Item Image Path | The URL or file path that specifies the location of the image file used for display in the application. |
| Like Location | Drop-down measure used to assign an existing store to a new store, allowing the new store to inherit and use prior year sales data (sales retail, units, and gross margin) as its baseline for planning and clustering. |
| Location Active | Boolean measure used to designate a location as active or inactive. Inactive locations are excluded from planning segments and the Location Clustering process. |
| Location Attribute | Measure that reflects the assigned attribute values (such as region, format, or cluster drivers) to a location. |
| Location Attribute 1,2,3 | Drop-down measures used to define dynamic attribute-based hierarchies for location roll up and analysis. |
| Location Attribute Label | The display name for a location attribute used to categorize and differentiate stores. |
| Location Count | Number of locations for the current level being planned/ reviewed |
| Location Description | Optional description assigned to a location, used as a reference and available as a dimension attribute in clustering and analysis. |
| Location Space | Details the space capacity for each store, such as fixtures, square footage, or square meters, based on integrated data. |
| Location Type | Identifies the type of location (for example, physical store or direct/online location), used to differentiate how locations are included in planning and analysis. |
| Lower Breakpoint Boundary | Lower limit for each performance or space group. |
| LP AP EOP C, R, U | Approved plan end-of-period inventory cost, retail and units by department, location, and week. |
| LP AP Receipts C, R, U | Approved plan receipts cost, retail and units by department, location, and week. |
| LP AP Sales C, R, U | Approved plan sales cost, retail and units by department, location, and week. |
| Ly Avg ROS Reg+Promo U | Last year average rate of sale units (regular and promotional). |
| Ly Avg ROS U | Last year average rate of sale units. |
| Ly GM %, R | Last year gross margin rate (percentage) and retail. |
| Ly GM Reg+Promo %, R | Last year gross margin percentage and retail (regular and promotional). |
| Ly Option Assorted Count | Number of items included in last year’s assortment. |
| Ly Option Count | Last year option (item, style color) count. |
June 16, 2026 Appendix A-3 of A-9
Appendix A
| Measure Name | Description |
|---|---|
| Ly Option Count contrib Prod % | Last year option count contribution percentage to total product. |
| Ly Optz Avg ROS U | Last year optimized history average rate of sale units. |
| Ly Optz Option Count | Last year optimized history option count. |
| Ly Optz Option Count contrib Prod % | Contribution of optimized history option count by attribute value to product attribute type. |
| Ly Optz Sales U | Last year optimized history sales units. |
| Ly Optz Sales U contrib Prod % | Contribution of last year optimized history sales units to total product. |
| Ly Sales AUR, R | Last year average unit retail and retail. |
| LY Sales R contrib Prod % | Last year sales retail contribution percentage to total product. |
| Ly Sales Reg+Promo R, U | Last year sales retail and units (regular and promotional). |
| Ly Sales U | Last year sales units |
| LY Sales U contrib Prod % | Last year sales units contribution percentage to total product |
| LY Week Map | Identifies the prior year week mapped to the current year week for accurate year-over-year comparison. |
| Maximum Initial Receipt Lead Time | Maximum number of weeks before the start of the period that receipts can arrive. |
| MFP Cp Avg ROS Reg+Promo U | MFP current plan average rate of sale units (regular and promotional). |
| MFP CP EOP R, C, U | MFP current plan end-of-period inventory retail, cost, and units. |
| MFP Cp GM Reg+Promo %, R | MFP current plan gross margin percentage and retail (regular and promotional). |
| MFP CP Receipts R, C, U | MFP current plan receipts retail, cost, and units. |
| MFP CP Sales Reg+Promo R, C, U | MFP current plan regular and promotional sales retail, cost, and units. |
| MFP Tgt, Fcst, Actual Sales Curve U % | Displays the percent-to-total distribution of sales units for MFP, Forecast, and Actual data for the selected Curve Source (Year). |
| MFP Tgt, Fcst, Actual Sales U | Displays MFP current plan, forecast, and actual sales units for the selected Curve Source (Year). |
| Op Avg ROS U | Original plan average rate of sale units. |
| Op BOP R, U | Original plan beginning of period retail and units. |
| Op GM %, R | Original plan gross margin percentage (rate) and retail. |
| Op Receipts U | Original plan receipt units. |
| Op Sales R, U | Original plan sales retail and units. |
| Op Sell Thru % | Original plan sell-through percentage. |
| Other Attribute Values | Defines the label used for grouped attribute values (for example, “other”) created through threshold logic. This label is defined by attribute type and can be modified. |
| Override Cluster Label | Optional field to rename clusters for improved clarity in downstream processes. |
| Override Perf Group | Planner-defined override of performance group assignment. If you use the override, you must rerun the Create Cluster Application Action to update cluster results. |
| Perf Group | Performance group assignment based on Breakpoint algorithm. |
June 16, 2026 Appendix A-4 of A-9
Appendix A
| Measure Name | Description |
|---|---|
| Perf Group (Optimized) | Performance group assignment based on Optimized algorithm. |
| Perf Group Score % | Relative performance ranking of a location within the dataset (0%–100%). |
| Product Attribute | Drop-down measure used to assign attribute values to a style-color item. |
| Product Attribute 1,2,3 | Drop-down measures used to define dynamic attribute-based hierarchies for product rollup and analysis. |
| Product Attribute Label | The display name for a product attribute or its associated attribute values. |
| Product Attribute Picklist Eligibility | Controls which attribute values are available in picklists for a product category (class). Enabled values are available to planners within Assortment Planning displays. |
| Rate of Sales U | Average weekly sales units for the selected data set, displayed by attribute. |
| Rec Attribute Rank | Ranking of each attribute type for the selected subclass based on AI-driven recommendations. |
| Rec Attribute Type Rank | Ranking of each attribute type for the selected subclass, supporting attribute value selection. |
| Rec Avg ROS U | Recommended average rate of sale units. |
| Rec GM %, R | Defines recommended gross margin percentage (rate) and retail. |
| Rec Item Rank | Defines item ranking based on sales potential. |
| Rec Item Status | Defines recommended item status based on replenishment flag, on-order, and receipt timing. |
| Rec Option Assorted | Defines system-recommended assortment selection for each option. |
| Rec Option Count | Recommended option count. |
| Rec Option Count contrib Prod % | Recommended option count contribution percentage for each attribute value relative to the subclass total. |
| Rec Option Count – Fcst | Recommended option count based on forecast data. |
| Rec Option Count – Ly | Recommended option count based on last year sales. |
| Rec Option Count – Ly Optz | Recommended option count based on optimized history. |
| Rec Option Count – MFP | Recommended option count based on MFP. |
| Rec Sales Potential C, R, U | Defines recommended sales potential cost, retail and units. |
| Rec Sales U | Recommended sales units. |
| Rec Sales U contrib Prod % | Recommended contribution percentage of sales units by attribute value. |
| Recommend Attribute Mix | Boolean measure that enables execution of the Rec Attribute Mix application action to generate recommended attribute mix outputs, including Rec Attribute Type Rank and Ly Optz Option Count contrib Prod %, which translate customer behavior by attribute and serve as the foundation for defining assortment strategy targets. |
| Rename Item Id | Editable measure used to map a placeholder SKU to a finalized or external SKU identifier. |
| Rename Style Id | Editable measure used to map a placeholder style to a finalized or external style identifier. |
| Rename Style/Color Id | Editable measure used to map a placeholder style-color to a finalized or external style-color identifier. |
| Sales Curve % | Defines the weekly percent-to-total sales distribution for the curve. |
| Sales Curve Start Week | Indicates the starting week of the sales curve relative to the assortment period. |
| Sales Reg+Promo R, U, AUR | Sales retail, units, and AUR based on selected data source and calendar. |
June 16, 2026 Appendix A-5 of A-9
Appendix A
| Measure Name | Description |
|---|---|
| Sales Score | Scaled Scoring value based on selected metrics and weights. |
| Sales U % | Contribution of sales units by attribute relative to total sales. |
| Sales Weight AUR | Percentage weight assigned to sales average unit sales retail for the selected clustering strategy. Used in calculating the combined scoring index for location clustering. |
| Sales Weight R | Percentage weight assigned to sales retail for the selected clustering strategy. Used in calculating the combined scoring index for location clustering. |
| Sales Weight U | Percentage weight assigned to sales units for the selected clustering strategy. Used in calculating the combined scoring index for location clustering. |
| Seed Source | Drop-down measure used to select the data source (MFP, Forecast, or Actuals) used to populate the curve. |
| Select Strategy Weight | Drop-down measure used to select predefined strategy weights for the category. Location Strategies may be created in Planning Administration Task for seeding. |
| Slow Intro Curve % | Defines the percentage distribution of demand for items with gradual sales ramp-up. |
| Space Source | Picklist detailing the metric that defines the values to be used when detailing clusters. These have been configured and loaded into APCS from external sources. |
| Start Date | First date of the assortment period. |
| Start Week | First week of the assortment period, derived from Start Date. |
| Style Id | Identifier assigned within APCS to represent a placeholder at the style level. |
| Style/Color Id | Identifier assigned within APCS to represent a placeholder at the style-color level. |
| System Loaded Cost | Cost value for an item integrated into APCS from the source system. |
| System Loaded Retail | Retail value for an item integrated into APCS from the source system. |
| Tgt Option Count | Defines the target option count approved in Assortment Strategy. |
| Tgt Option Count contrib Prod % | Defines the target contribution percentage of option count by attribute value from Assortment Strategy. |
| Trending Curve % | Defines the percentage distribution of demand for items with faster ramp-up. |
| TY EOP C, R, U | Actual end-of-period inventory cost, retail, and units by item, location, and week. |
| TY Net Sales C, R, U | Actual sales cost, retail and units by item, location, and week. |
| TY Receipts C, R, U | Actual receipt cost, retail and units by item, location, and week. |
| Upper Breakpoint Boundary | Upper limit for each performance group. Adjustments impact grouping logic for the current session only. |
| Use Optimized Perf Group | Boolean measure that enables the optimized clustering algorithm. |
| Use Optimized Space Group | Boolean measure that enables the optimized clustering algorithm. |
| View/Manage Images | Provides access to image management for a product attribute value through right-click navigation to the View/Manage Images dialog. |
| Week ID | Represents the sequential week identifier for the current year calendar. |
| Wp Approval Info | Provides status or details related to approval. |
| Wp Approve AS Target Wp Approve Comment | Boolean measure that flags the assortment strategy for approval prior to executing Approve Targets. Defines planner comments associated with approval. |
June 16, 2026 Appendix A-6 of A-9
Appendix A
| Measure Name | Description |
|---|---|
| Wp Approve Exceptions | Boolean measure that enables execution of the Approve Exceptions application action. |
| Wp Approve Item Flow | Boolean measure that enables execution of the Approve Item Flow application action. |
| Wp Assort Strategy Seed Info | Provides context for the selected seed source. |
| Wp Assort Strategy Seed Source | Defines the data source used to generate assortment strategy recommendations (Last Year, Optimized History, Forecast, or MFP). |
| Wp Attribute Value Threshold Ly Sales | Working Plan Attribute Value Threshold for Last Year Sales. This helps to determine what Attribute Values should be treated as individual key contributors. Anything below the threshold will be grouped as z_others |
| Wp Avg ROS U | Working plan average rate of sale units. |
| Wp Avg ROS U (Initial) | Defines initial working plan average rate of sale units. |
| Wp BOP R, U | Working plan beginning of period retail and units. |
| Wp BOP R var Op % | Variance of working plan beginning of period retail to Original Plan. |
| Wp Buy Qty U | Defines working plan buy quantity units (receipt for total Assortment Period). |
| Wp Copy Like Item | Copies parameters and settings from a selected like item to the current item. |
| Wp Cost | Cost value used within APCS, based on the override value when provided, otherwise defaulting to the system-loaded value. |
| Wp Cost (Override) | Editable cost value for an item, typically used to set or adjust pricing for placeholder items at the location level. |
| Wp Create Sales and Receipt Plan | Boolean measure that enables execution of the Create Sales and Receipt Plan application action. |
| Wp Dept Location Exclusion | Boolean measure used to define store participation by department. A value of true indicates the store is included in clustering and assortment planning for that department, while false indicates the store is excluded. |
| Wp Exception Store Count | Defines the number of stores marked as exceptions for each style-color. |
| Wp Export Placeholders | Boolean measure that flags placeholders for export and enables execution of the Export Placeholders application action. |
| Wp Forward Cover (Weeks) | Working plan forward cover in weeks. |
| Wp Generate Sales Potential | Boolean measure that enables execution of the Generate Sales Potential application action. |
| Wp GM %, R | Working plan gross margin percentage (rate) and retail. |
| Wp GM % (Initial) | Defines initial working plan gross margin percentage. |
| Wp Item Intent | Defines the role of the item (mandatory, high ROS, average ROS, promotional). Influences sales potential and assortment prioritization. |
| Wp Item Rank | Defines item ranking based on selected KPI and threshold criteria. |
| Wp Item Store Exception | Defines store-level exceptions for each style-color and store combination based on attribute or item rules. |
| Wp KPI for Ranking | Defines the KPI used to rank items (Sales C, Sales R, Sales U, GM R, GM %). |
| Wp Min Order Qty U | Defines minimum order quantity units. |
| Wp On Order R, U | Working plan on-order retail and units. |
| Wp Option Assorted | Defines planner-selected assortment. True indicates the item is included. |
| Wp Option Assorted Count | Defines the working plan assorted option count. |
June 16, 2026 Appendix A-7 of A-9
Appendix A
| Measure Name | Description |
|---|---|
| Wp Option Assorted Count contrib Prod % | Defines the working plan contribution percentage of assorted options by attribute value. |
| Wp Option Assorted Count diff Tgt | Defines the difference between working plan assorted option count and target option count. |
| Wp Option Count | Defines the planned number of options. Initially aligns with the recommended option count and can be adjusted. |
| Wp Option Count (Override) | Defines the user-adjusted option count at the attribute value level. |
| Wp Option Count contrib Normalized % | Normalized working plan contribution percentages when values exceed 100% within an attribute type. |
| Wp Option Count contrib Prod % | Defines the option count contribution percentage for each attribute value relative to the subclass total. |
| Wp Option Count Diff to Rec | Defines the difference between working plan option count and recommended option count. |
| Wp Order Frequency (Weeks) | Defines receipt frequency in weeks. |
| Wp Planning Method | Defines the planning method (Single Drop or Multiple Drop). |
| Wp Pres Min U | Defines presentation minimum units. |
| Wp Prod Attribute Store Exception | Defines planner-controlled attribute-level store exclusions for the current assortment. |
| Wp Rank by Actuals Only | Boolean measure that controls whether ranking is based on actuals only or actuals plus plan. |
| Wp Receipt First Date | Defines first receipt date used to evaluate lifecycle and continuation decisions. |
| Wp Receipts R, U | Working plan receipt retail and units. |
| Wp Receipts R var Ly % | Variance of working plan receipts retail to last year receipts retail. |
| Wp Receipts R var MFP % | Variance of working plan receipts retail to MFP receipts retail. |
| Wp Receipts R var Op % | Variance of working plan receipts retail to Original Plan. |
| Wp Retail Price | Retail value used within APCS, based on the override value when provided, otherwise defaulting to the system-loaded value. |
| Wp Retail Price (Override) | Editable retail value for an item, typically used to set or adjust pricing for placeholder items at the location level. |
| Wp Safety Stock (Weeks) | Defines safety stock coverage in weeks. |
| Wp Sales Basis | Defines the source used to trend sales (such as, Op or Ly). |
| Wp Sales Curve Source | Defines the selected sales curve used to distribute sales across weeks. |
| Wp Sales R, U | Working plan sales retail and units. |
| Wp Sales R (Initial) | Defines initial working plan sales retail. |
| Wp Sales R contrib Prod % | Defines the contribution of working plan sales retail by attribute value. |
| Wp Sales R var Cp % | Variance of working plan sales retail to current plan. |
| Wp Sales R var Ly % | Variance of working plan sales retail to last year sales retail. |
| Wp Sales R var MFP % | Variance of working plan sales retail to MFP sales retail. |
| Wp Sales R var Op % | Variance of working plan sales retail to Original Plan. |
| Wp Sales U (Initial) | Defines initial working plan sales units. |
| Wp Sales U contrib Prod % | Defines contribution of planned sales units by attribute value relative to the subclass total. |
| Wp Sales U var Cp % | Variance of working plan sales units to current plan. |
June 16, 2026 Appendix A-8 of A-9
Appendix A
| Measure Name | Description |
|---|---|
| Wp Sales U var Ly % | Variance of working plan sales units to last year sales units. |
| Wp Sales U var MFP % | Variance of working plan sales units to MFP sales units. |
| Wp Sales U var Op % | Variance applied to original plan sales units. |
| Wp Select Attribute Type | Boolean measure that identifies attribute types to be included in Assortment Strategy. Selected attributes define the key drivers of demand used in downstream planning. |
| Wp Select Category 1, 2, 3, 4 | Defines a subclass used as a filter in the Cross Category visual and table views. |
| Wp Sell Thru % | Working plan sell-through percentage. |
| Wp Sell Thru % (Initial) | Defines initial working plan sell-through percentage. |
| Wp Sell Thru Target % | Defines the sell-through threshold used to trigger alerts; displayed as Target Sell Thru %. |
| Wp Store Count | Defines the number of stores considered for each style-color in the working plan. |
| Wp Update Sales & Receipt Plan | Triggers recalculation of working plan sales and receipts. |
| Wp Week End | Defines planned selling end week. |
| Wp Week Start | Defines planned selling start week. |
June 16, 2026 Appendix A-9 of A-9
In this guide
- Guide: Assortment Planning Cloud Service User Guide
- Previous: 9 Item Flow Task
- Next: B Appendix: Glossary of Real Time Alerts