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.
D
Appendix: Promotion and Markdown - Run Overview
This table provides information about table columns and calculations for Promotion and Markdown Optimization runs.
| Column Heading | Default (Y/N) | Definition | DB Reference / Calculation Table Name: PRO_RUN_HDR_VW |
|---|---|---|---|
| Run Id | Y | System-generated unique identifier for the run. | RUN_HDR_ID |
| Finalized | Y | This flag indicates that recommendations from this run is finalized and used in the Manage Recommendations screen. | FINALIZED_FLG |
| Run Name | Y | User provided name for the run. | RUN_NAME |
| Run Description | N | User provided description for the run. | RUN_DESCR |
| Pricing Objective | Y | A description of the objective used for the run. For example, Increase Gross Margin. | PRICING_OBJECTIVE_DES CR |
| Season | Y | A description of the Season. | SEASON_NAME |
| Department | Y | A description of the Department. | CONCAT(PROD_HIER_EXT _CODE,”-“,PROD_HIER_NA ME) |
| Price Zone | Y | Price zone of the item recommendation. Corresponds to the run setup level. | CONCAT(PRICE_ZONE_GR P_EXT_CODE,”-“,PRICE_ZO NE_GRP_NAME) |
| Company | 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) | CONCAT(PRICE_ZONE_EX T_CODE,”+“,PRICE_ZONE_ NAME) |
| Effective Week | Y | The week ending date for which the run was executed. | CONCAT(LOC_HIER_EXT_C ODE,”+“,LOC_HIER_NAME) |
May 15, 2026 Appendix D-1 of D-3
Appendix D
| Column Heading | Default (Y/N) | Definition | DB Reference / Calculation Table Name: PRO_RUN_HDR_VW |
|---|---|---|---|
| Strategy | Y | The strategy used for the optimization of the run. It can be either the DEFAULT STRATEGY or other custom strategy. | RULE_SET_NAME |
| Proj Rev | Y | Projected Revenue (AMT) for the run is the revenue generated by optimization in the run’s currency. | REVENUE |
| Rev %CHG | Y | Projected Revenue (%CHG) is the% revenue gain compared to the current price policy. | PCT_REVENUE_CHG |
| Proj Gross Margin | Y | Projected Gross Margin (AMT) for the run is the gross margin generated by optimization in the run’s currency. | GROSS_MARGIN |
| GM %CHG | Y | Projected Gross Margin (CHG) is the% gross margin gain compared to the current price policy. | PCT_GMARGIN_CHG |
| Proj Sell Thru | Y | Projected Sell Through (PCT) for the run is the sell-through generated by optimization. | SELL-THROUGH |
| Sell Thru %CHG | Y | Projected Sell Through (%CHG) is the% gain in Sell- through over the current price policy. | PCT_SELL-THROUGH_CHG |
| Proj Sls Units | Y | Project sales unit generated by optimization. | OPTIMAL_FORECASTED_S ALES |
| Proj Promo Budget (Life) | Y | Projected lifetime promotion budget by optimization. | PROMO_BUDGET_USED |
| Proj Mkdn Budget (Life) | Y | Projected lifetime markdown budget by optimization. | MKDN_BUDGET_USED |
| Total Item Cnt | Y | Total item count | ITEM_OPTIMIZED_COUNT |
| No Rec Item Cnt | Y | Total items that are in ‘No Recommendation’ status | ITEM_NOREC_COUNT |
| Non-fcst Item Cnt | Y | Total items not included in forecast. | ITEM_NONFCST_COUNT |
| Promo Item Cnt | Y | Total items included in promotion. | ITEM_PROMO_COUNT |
| Mkdn Item Cnt | Y | Total items included in markdown. | ITEM_MKDN_COUNT |
| Plan Event Item Cnt | Y | Total items included in planned events. | ITEM_PLAN_PROMOTION_ COUNT |
| Usr Ovrd Item Cnt | Y | Total items that are overridden by user | ITEM_USR_OVRD_COUNT |
May 15, 2026 Appendix D-2 of D-3
Appendix D
| Column Heading | Default (Y/N) | Definition | DB Reference / Calculation Table Name: PRO_RUN_HDR_VW |
|---|---|---|---|
| Sell Thru Fcst | Y | Projected Sell Through Forecast (PCT) for the run is the sell-through generated by optimization. | SELL_THRU_FCST |
| Sell Thru Fcst %CHG | Y | Projected Sell Through Forecast (%CHG) is the% gain in sell-through over the current price policy. | PCT_SELL_THRU_FCST_C HG |
| Run Status | Y | Status of the run. | RUN_STATUS_DESCR |
| Status Update | Y | The date when the run status was updated. | CHANGED_ON_DT |
| Optimized On | Y | The date when the run was optimized. | LAST_EXECUTION_DATE |
| Modified By | Y | Login ID of the user who modified the run. | CHANGED_BY_USER |
| Created By | Y | Login ID of the user who created the run. | CREATED_BY_USER |
| Created Date | Y | The date when the run was first created. | CREATED_ON_DT |
May 15, 2026 Appendix D-3 of D-3
In this guide
- Guide: Lifecycle Pricing Optimization User Guide
- Previous: C Appendix: Regular - Pricing Optimization Rules
- Next: E Appendix: Regular - Run Overview
Related chapters
- E Appendix: Regular - Run Overview — Lifecycle Pricing Optimization User Guide · shares
CHANGED_BY_USER,CREATED_BY_USER,CREATED_ON_DT,FINALIZED_FLG - B Appendix: Regular - Run Overview — Lifecycle Pricing Optimization Rule Based Regular Pricing User Guide · shares
CHANGED_BY_USER,CREATED_BY_USER,CREATED_ON_DT,FINALIZED_FLG - F Appendix: Promotion and Markdown - Manage Recommendations — Lifecycle Pricing Optimization User Guide · shares
CHANGED_BY_USER,LAST_EXECUTION_DATE,MKDN_BUDGET_USED,OPTIMAL_FORECASTED_SALES