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.
H
Appendix: Promotion and Markdown - Review Forecast
This table provides information about table columns and calculations for Promotion and Markdown Review Forecasts.
| Column Heading | Default (Y/N) | Definition | DB Reference / Calculation |
|---|---|---|---|
| Class / Subclass / Style / Color / Customer Segment | Y | Product Hierarchy (Depending on the Filter) | CONCAT(RSE_PROD_HIER. PROD_EXT_CODE,’-‘,RSE_ PROD_HIER.NAME)Based on RSE_PROD_HIER.HIER_LE VEL_ID |
| Price Zone | Y | Price zone of the item recommendation. Corresponds to the run setup level. | RSE_PRICE_ZONE and RSE_PRICE_ZONE_GRP |
| Company (Dynamic Level) | Y | Location of the item recommendation. (For example, Region, Channel, and so on). Corresponds to the run location setup level. Will be chain when using price zones. PRO_DB_PARAMETER_VW; #PRO_LOC_HIER_PROCESSING_LVL = 1 (RSE_HIER_LVL) | RSE_LOC_HIER |
| Week Ending Date | Y | PRO_RUN_RECOM_OPT_R ESULT.CAL_HIER_ID JOIN WITHRSE_CAL_HIER ON ID to get CAL_TO_DT | |
| Current Gross Margin | Y | Gross Margin generated by the product using the current price. | CURRENT_GROSS_MARGI N |
| Current Forecasted Demand | Y | Forecast demand calculated by the optimization process using the current price. | CURRENT_FORECASTED_ DEMAND |
| Current Remaining Inventory | Y | End of week inventory using the CURRENT_FORECASTED_ SALES. | CURRENT_REMAINING_IN VENTORY |
| Current Forecasted Sales | Y | Forecast sales calculated by the optimization process using the current price. | CURRENT_FORECASTED_ SALES |
| Proj Inv End of Wk | Y | Projected inventory at the end of the effective week, including any applied overrides. | PRO_RUN_RECOM_OPT_R ESULT.OPTIMAL_REMAININ G_INVENTORY |
May 15, 2026 Appendix H-1 of H-3
Appendix H
| Column Heading | Default (Y/N) | Definition | DB Reference / Calculation |
|---|---|---|---|
| Proj Sls Units | Y | Projected Sales Units for the Effective Week, including any applied overrides. | PRO_RUN_RECOM_OPT_R ESULT.OPTIMAL_FORECAS TED_SALES |
| Proj Sls Rev | Y | Projected Sales Revenue for the Effective Week, including any applied overrides. | PRO_RUN_RECOM_OPT_R ESULT.OPTIMAL_REVENUE |
| Tkt Price | Y | Ticket Price of the item. Reflects TRAN TYPE 0, 4, 8. Rolled up from leaf node levels (For example, SKU- STORE) using Most Common Value. | PRO_RUN_RECOM_OPT_R ESULT.CURRENT_PRICE |
| Proj Tkt Price | Y | Projected ticket Price of the item for the Effective Week. Reflects TRAN TYPE 0, 4, 8. Rolled up from leaf node levels (For example, SKU- STORE) using Most Common Value. | |
| Proj Sls Price | Y | Projected Sales Price for the Effective Week, including any applied overrides. | PRO_RUN_RECOM_OPT_R ESULT.OPTIMAL_PRICE |
| Base Sales Units | Y | The expected sales volume for the effective week after adjusting the base demand for seasonality effects. | BASE_DEMAND * SEASONALITY_INDEX |
| Sales Units from Price Changes | Y | The change in unit sales driven by applying the optimal price effect to the base demand. | Base Sales Units * OPTIMAL_PRICE_EFFECT - BASE_DEMAND |
| Sales Units from Planned Events | Y | The change in unit sales due to planned promotional activities compared to the base demand. | Base Sales Units * PLANNED_PROMOTION_LI FT - BASE_DEMAND |
| Cumulative Sales Units | Y | The running total of Proj Sls Units from the last actual date. | Cumulative Sum of PRO_RUN_RECOM_OPT_R ESULT.OPTIMAL_FORECAS TED_SALES |
| Demand Units at Full Price | Y | Units expected to be sold at the full price. | |
| Base Demand | Y | The estimated sales volume before applying any promotional, markdown `or seasonal adjustments. | BASE_DEMAND |
| Item Count | Y | The total number of items included in the product hierarchy. For example, it is 1 if product hierarchy is style - color. | |
| No Recom Item Count | Y | The number of items for which no new price recommendation was generated. |
May 15, 2026 Appendix H-2 of H-3
Appendix H
| Column Heading | Default (Y/N) | Definition | DB Reference / Calculation |
|---|---|---|---|
| Under 30% 30%-50% | Y Y | Count of Promotion/ Markdown - Under 30%. Count of Promotion/ Markdown - 30% to 50% | (PRO_RUN_RECOM_OPT_ RESULT.CURRENT_PRICE- PRO_RUN_RECOM_OPT_R ESULT.OPTIMAL_PRICE)/ PRO_RUN_RECOM_OPT_R |
| Over 50% | Y | Count of Promotion/ Markdown - Over 50%.. | ESULT.CURRENT_PRICE |
| Week Start Date | Y | Promotion/Markdown event start date. | PRO_RUN_RECOM_OPT_R ESULT.CAL_HIER_IDJOIN WITHRSE_CAL_HIER ON ID to get CAL_FROM_DT |
May 15, 2026 Appendix H-3 of H-3
In this guide
- Guide: Lifecycle Pricing Optimization User Guide
- Previous: G Appendix: Regular - Manage Recommendations
Related chapters
- F Appendix: Promotion and Markdown - Manage Recommendations — Lifecycle Pricing Optimization User Guide · shares
CURRENT_FORECASTED_SALES,CURRENT_GROSS_MARGIN,CURRENT_PRICE,G_INVENTORY - G Appendix: Regular - Manage Recommendations — Lifecycle Pricing Optimization User Guide · shares
CURRENT_PRICE,HIER_LEVEL_ID,OPTIMAL_FORECASTED_SALES,OPTIMAL_REMAINING_INVENTORY - C Appendix: Regular - Manage Recommendations — Lifecycle Pricing Optimization Rule Based Regular Pricing User Guide · shares
PROD_EXT_CODE,PRO_RUN_RECOM_OPT_RESULT,RSE_PRICE_ZONE,RSE_PROD_HIER - 23 Targeted Items Recommendation — AI Foundation Implementation Guide · shares
CAL_HIER_ID,HIER_LEVEL_ID,RSE_LOC_HIER,RSE_PROD_HIER