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.
G Appendix: Regular - Manage Recommendations
This table provides information about table columns and calculations for Regular Optimization recommendations.
| Colu mn Hea ding | Def ault (Y/N ) | Applica bility (Foreca st or Non- Forecas t/Rules Based) | Definition | DB Reference / Calculation |
|---|---|---|---|---|
| Imag e | Y | Both | #N/A | N/A |
| Flag | Y | Both | Users can flag the recommendation for further review. | PRO_REG_RUN_RECOM_O PT_RESULT.FCST_REVIEW_ CODE |
| Note s | Y | Both | Users can enter any comment for the recommendation. For e.g., Additional Budget received so overriding to a deeper markdown. | PRO_REG_RUN_RECOM_O PT_RESULT.FCST_NOTE |
| Ovrd Statu s | Y | Both | Shows whether the item has any pending recalculate. It shows which user requested it. | PRO_REG_RUN_RECOM_O PT_RESULT.CHANGED_BY_ USER |
| Com pany | Y | Both | Location of the item recommendation. (For e.g Region, Channel, etc). 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 |
| Item Desc r | Y | Both | Item description, external code, and name separated in different columns | RSE_PROD_HIER.DESCR RSE_PROD_HIER.HIER_LEV EL_ID=8 |
| Bran d Nam | Y | Both | Name of the brand. | RSE_PROD_GRP.NAME |
| e | ||||
| Price Zone | Y | Both | Price zone of the item recommendation. Corresponds to the run setup level. | RSE_PRICE_ZONE and RSE_PRICE_ZONE_GRP |
| Rec Statu s | Y | Both | Recommendation status of the item, which says Ready for Review→ Reviewed → Approved/Submitted/Taken → Export Failed | PRO_REG_RUN_RECOM_O PT_RESULT.RECOMMENDAT ION_STATUS_ID Join With PRO_RECOMMENDATION_S TATUS on ID to get UI_NAME. |
May 15, 2026 Appendix G-1 of G-8
Appendix G
| Colu mn Hea ding | Def ault (Y/N ) | Applica bility (Foreca st or Non- Forecas t/Rules Based) | Definition | DB Reference / Calculation |
|---|---|---|---|---|
| Tkt Price | Y | Both | Ticket Price of the item. Reflects TRAN TYPE 0, 4, 8. Rolled up from leaf node levels (e.g. SKU-STORE) using Most Common Value | PRO_REG_RUN_RECOM_O PT_RESULT.CURRENT_PRIC E |
| Reg Price | Y | Both | Regular Price of the item. Reflects TRAN TYPE 0, 4. Rolled up from leaf node levels (e.g. SKU-STORE) using Most Common Value | PRO_REG_RUN_RECOM_O PT_RESULT.LAST_REGULAR _PRICE |
| Orig Price | Y | Both | Original Price of the item. Reflects TRAN TYPE 0. Rolled up from leaf node levels (e.g. SKU-STORE) using Most Common Value | PRO_REG_RUN_RECOM_O PT_RESULT.REGULAR_PRIC E |
| Eff Price | Y | Both | Effective Price of the item - it will reflect either the recommended or the overriden/user added price. If the recommendation is rejected, then it will reflect the ticket price of the item. | Calculated during optimization and displayed in the UI. |
| Eff Rec Type | Y | Both | Effective Recommendation Type of the item. It will be recommended, or the overridden/user added or rejected action. | Calculated during optimization and displayed in the UI. |
| Eff Start Dt | Y | Both | Effective start date of the recommendation. Reflect user date override as well. | PRO_REG_RUN_RECOM_O PT_RESULT.EFF_START_DT |
| Eff %Ch g of Tkt | Y | Both | Effective % Change of Average Ticket Value, compared to a previous period (like LFY, LFQ, etc.). | Calculated during optimization and displayed in the UI. |
| Eff %Ch g of Orig | Y | Both | Effective Percentage Change of Original Price, compared to a previous period (like LFY, LFQ, etc.). | Calculated during optimization and displayed in the UI. |
| Eff %Ch g of Reg | Y | Both | Effective Percentage Change of Regular Price, compared to a previous period (like LFY, LFQ, etc.). | Calculated during optimization and displayed in the UI. |
| Rec Price | Y | Both | Recommended Price of the Item | PRO_REG_RUN_RECOM_O PT_RESULT.RECOM_PRICE |
| Rec Type | Y | Both | Recommendation Type of the Item. Markdown, Promotion, No Recommendation, Non- forecasted | PRO_REG_RUN_RECOM_O PT_RESULT.PRICE_RECOM_ TYPE_ID Join with PRO_PRICE_RECOM_TYPE on ID to get DESCR |
| Rec %Ch g of Tkt | Y | Both | Recommended Percentage Change of Ticket. | Calculated during optimization and displayed in the UI. |
| Rec %Ch g of Orig | Y | Both | Recommended Percentage Change of Original Price. | Calculated during optimization and displayed in the UI. |
May 15, 2026 Appendix G-2 of G-8
Appendix G
| Colu mn Hea ding | Def ault (Y/N ) | Applica bility (Foreca st or Non- Forecas t/Rules Based) | Definition | DB Reference / Calculation |
|---|---|---|---|---|
| Proj Sls Units | Y | Forecast Only | Projected Sales Units for the Effective Week, including any applied overrides. | PRO_REG_RUN_RECOM_O PT_RESULT.OPTIMAL_FORE CASTED_SALES |
| Proj Sls Rev | Y | Forecast Only | Projected Sales Revenue for the Effective Week, including any applied overrides. | PRO_REG_RUN_RECOM_O PT_RESULT.OPTIMAL_REVE NUE |
| Proj GM | Y | Forecast Only | Projected Gross Margin $ for the Effective Week, including any applied overrides. | PRO_REG_RUN_RECOM_O PT_RESULT.OPTIMAL_GROS S_MARGIN |
| Last Act Inv | Y | Forecast Only | Inventory for the Last Actual Week (or Processing Week). It is the sum of all inventory components that are configured to be used for optimization. | PRO_REG_RUN_RECOM_O PT_RESULT.INV_QTY_LAD |
| Total Buy | Y | Forecast Only | It is sum of Cumulative Sls Units and the Last Act Inv. Cumulative Sls Units is calculated from the first receipt date. | PRO_REG_RUN_RECOM_O PT_RESULT.INITIAL_INVENT ORY |
| Run Id and Nam e | Y | Both | ID of optimization run generating rec | CONCAT(PRO_RUN_HDR.ID,’ -‘,PRO_RUN_HDR.NAME) |
| Opti mizat ion | Y | Both | Date of optimization run | PRO_RUN_HDR.LAST_EXEC UTION_DATE |
| Date | ||||
| Reca lculat ion Date | Y | Both | Date when the item is recalculated | PRO_REG_RUN_RECOM_O PT_RESULT.RECALCULATE_ DT |
| Reca lculat ion User | Y | Both | User who last requested the recalculate | PRO_REG_RUN_RECOM_O PT_RESULT.RECALCULATE_ BY_USER |
| Expo rted On Date | Y | Both | Date when the item is Approved | PRO_REG_RUN_RECOM_O PT_RESULT.EXPORTED_ON _DT |
| Appr oved By User | Y | Both | User who approved the recommendation. | PRO_REG_RUN_RECOM_O PT_RESULT.EXPORTED_BY_ USER |
| LFY Rev | Y | Forecast Only | Last Fiscal Year Revenue - The total revenue a company made during its most recently completed fiscal year. | PRO_REG_RUN_RECOM_DE NORMALIZE.LFY_REVENUE |
| LFY H Rev | Y | Forecast Only | Last Fiscal Year Half Revenue - The revenue from the first or second half of the last fiscal year, depending on the context. | PRO_REG_RUN_RECOM_DE NORMALIZE.LFYH_REVENU E |
May 15, 2026 Appendix G-3 of G-8
Appendix G
| Colu mn Hea ding | Def ault (Y/N ) | Applica bility (Foreca st or Non- Forecas t/Rules Based) | Definition | DB Reference / Calculation |
|---|---|---|---|---|
| LFY Q Rev | Y | Forecast Only | Last Fiscal Year Quarter Revenue - Revenue from a specific quarter of the last fiscal year (like Q1, Q2, etc.) | PRO_REG_RUN_RECOM_DE NORMALIZE.LFYQ_REVENU E |
| LFH Rev | Y | Forecast Only | Last Fiscal Half Revenue - Revenue from the most recent half-year period in the last fiscal year. | PRO_REG_RUN_RECOM_DE NORMALIZE.LFH_REVENUE |
| LFQ Rev | Y | Forecast Only | Revenue from the Last Fiscal Quarter (e.g., Q4 ) | PRO_REG_RUN_RECOM_DE NORMALIZE.LFQ_REVENUE |
| LF2Q Rev | Y | Forecast Only | Revenue from the 2nd Last Fiscal Quarter (i.e., the quarter before LFQ - so if LFQ is Q4, this is Q3). | PRO_REG_RUN_RECOM_DE NORMALIZE.LF2Q_REVENU E |
| LFY Sls Units | Y | Forecast Only | Last Fiscal Year Total Sales Units - Total units sold across all quarters of the last fiscal year. | PRO_REG_RUN_RECOM_DE NORMALIZE.LFY_SALES |
| LFY H Sls Units | Y | Forecast Only | Last Fiscal Year Half Sales Units - Units sold during half of the last fiscal year (H1 or H2) | PRO_REG_RUN_RECOM_DE NORMALIZE.LFYH_SALES |
| LFY Q Sls Units | Y | Forecast Only | Last Fiscal Year Quarter Sales Units - E.g Q4 of last fiscal year. | PRO_REG_RUN_RECOM_DE NORMALIZE.LFYQ_SALES |
| LFH Sls Units | Y | Forecast Only | Last Fiscal Half Sales Units, The most recent half-year from LFY (either H1 or H2). | PRO_REG_RUN_RECOM_DE NORMALIZE.LFH_SALES |
| LFQ Sls Units | Y | Forecast Only | Last Fiscal Quarter Sales Units, The units sold in the most recent quarter of the last fiscal year. | PRO_REG_RUN_RECOM_DE NORMALIZE.LFQ_SALES |
| LF2Q Sls Units | Y | Forecast Only | 2nd Last Fiscal Quarter Sales Units, The units sold in the quarter before the last one. | PRO_REG_RUN_RECOM_DE NORMALIZE.LF2Q_SALES |
May 15, 2026 Appendix G-4 of G-8
Appendix G
| Colu mn Hea ding | Def ault (Y/N ) | Applica bility (Foreca st or Non- Forecas t/Rules Based) | Definition | DB Reference / Calculation |
|---|---|---|---|---|
| Ext Code , Nam e, Desc r of - Item / Divisi on / Grou p / Depa rtme nt / Class / Sub Class / | N | Both | Product Hierarchy | CONCAT(RSE_PROD_HIER.P ROD_EXT_CODE,’-‘,RSE_PR OD_HIER.NAME) Based on RSE_PROD_HIER.HIER_LEV EL_ID |
| Style / | ||||
| Style | ||||
| Color | ||||
| Chai n Ext Code / | N | Both | Location Hierarchy. N/A with Price Zones. | RSE_LOC_HIER_DH |
| Nam e / Desc r > Area | ||||
| > Regi on > Distri | ||||
| ct >Loc ation Ext Code / | ||||
| Nam e / Desc r | ||||
| Ovrd Price | N | Both | Overriden price for the item | PRO_REG_RUN_RECOM_O PT_RESULT.USR_OVRD_RE COM_PRICE |
May 15, 2026 Appendix G-5 of G-8
Appendix G
| Colu mn Hea ding | Def ault (Y/N ) | Applica bility (Foreca st or Non- Forecas t/Rules Based) | Definition | DB Reference / Calculation |
|---|---|---|---|---|
| Ovrd Price Type | N | Both | Override price type for the item | PRO_REG_RUN_RECOM_O PT_RESULT.USR_OVRD_PRI CE_RECOM_TYPE_ID JOIN WITH PRO_PRICE_RECOM_TYPE ON ID to get DESCR |
| Ovrd Price %Ch g of Tkt | N | Both | The percentage change in ticket price based on user-overridden prices, compared to a previous period or baseline. | Calculated during optimization and displayed in the UI. |
| Rec Acce pted? | N | Both | Y or No flag to denote whether recommendation was accepted as is or not. | PRO_REG_RUN_RECOM_O PT_RESULT.ACCEPTED_FLG |
| Proj Inv End of | N | Projected inventory at the end of the effective week, including any applied overrides. | PRO_REG_RUN_RECOM_O PT_RESULT.OPTIMAL_REMA INING_INVENTORY | |
| EW | ||||
| Start Dt | N | Both | Start date of the Item. For e.g., 2% ST or 3 weeks from first receipt date. | PRO_REG_RUN_RECOM_O PT_RESULT.MODEL_START_ DT |
| Final Ship Dt | N | Both | Denotes the calculated final ship date of the item. Last inventory change date that is older than x weeks (configuration) is assigned as the final ship date for the item | PRO_REG_RUN_RECOM_O PT_RESULT.FINAL_SHIP_DT |
| Sys Reco m Price | N | Both | System Recommended Price - Suggested by the pricing optimization system based on the rules, strategies, and algorithms it uses. | Calculated during optimization and displayed in the UI. |
| Sys Opt Sales Units | N | Forecast Only | The number of units the system predicts will be sold at the system-recommended price. | Calculated during optimization and displayed in the UI. |
| Sys Opt Reve nue | N | Forecast Only | The predicted revenue based on the system- recommended price and the corresponding system-optimized sales units. | Calculated during optimization and displayed in the UI. |
| Sys Opt Gros s Margi n | N | Forecast Only | The predicted gross margin based on the system’s pricing optimization. | Calculated during optimization and displayed in the UI. |
| Sys Opt Inv | N | Forecast Only | The inventory levels the system forecasts to meet the sales units needed at the system- recommended price. | Calculated during optimization and displayed in the UI. |
May 15, 2026 Appendix G-6 of G-8
Appendix G
| Colu mn Hea ding | Def ault (Y/N ) | Applica bility (Foreca st or Non- Forecas t/Rules Based) | Definition | DB Reference / Calculation |
|---|---|---|---|---|
| LFY GM | N | Forecast Only | Last Fiscal Year Gross Margin - The gross margin for the entire last fiscal year. | PRO_REG_RUN_RECOM_DE NORMALIZE.LFY_GROSS_M ARGIN |
| LFY H GM | N | Forecast Only | Last Fiscal Year Half Gross Margin - The gross margin for the first or second half of the last fiscal year | PRO_REG_RUN_RECOM_DE NORMALIZE.LFYH_GROSS_ MARGIN |
| LFY Q GM | N | Forecast Only | Last Fiscal Year Quarter Gross Margin - The gross margin for the last fiscal quarter of the previous year. | PRO_REG_RUN_RECOM_DE NORMALIZE.LFYQ_GROSS_ MARGIN |
| LFH GM | N | Forecast Only | Last Fiscal Half Gross Margin - The gross margin for half of the last fiscal year. | PRO_REG_RUN_RECOM_DE NORMALIZE.LFH_GROSS_M ARGIN |
| LFQ GM | N | Forecast Only | Last Fiscal Quarter Gross Margin - The gross margin for the most recent quarter of the last fiscal year. | PRO_REG_RUN_RECOM_DE NORMALIZE.LFQ_GROSS_M ARGIN |
| LF2Q GM | N | Forecast Only | Second Last Fiscal Quarter Gross Margin - The gross margin for the quarter before the most recent one in the last fiscal year. | PRO_REG_RUN_RECOM_DE NORMALIZE.LF2Q_GROSS_ MARGIN |
| Sys Mkdn Budg et | N | Forecast Only | The amount of the markdown budget that has been used by the system to products. | Calculated during optimization and displayed in the UI. |
| Used | ||||
| Max Com petito r | N | Both | Max competitor price of that item-location. | PRO_REG_RUN_RECOM_O PT_RESULT.MAX_COMPETIT OR_PRICE |
| Price | ||||
| Min Com petito r | N | Both | Min competitor price of that item-location. | PRO_REG_RUN_RECOM_O PT_RESULT.MIN_COMPETIT OR_PRICE |
| Price | ||||
| Avg Com petito r | N | Both | Average competitor price of that item-location. | PRO_REG_RUN_RECOM_O PT_RESULT.AVG_COMPETIT OR_PRICE |
| Price | ||||
| Most Com mon Com petito | N | Both | Most common competitor price of that item- location. | PRO_REG_RUN_RECOM_O PT_RESULT.MCV_COMPETIT OR_PRICE |
| r Price | ||||
| Targe t ST EOL | N | Forecast Only | Business rule - Percentage of sell-through for each product at end of clearance season | PRO_REG_RUN_RECOM_O PT_RESULT.TARGET_ST_PC T |
May 15, 2026 Appendix G-7 of G-8
Appendix G
| Colu mn Hea ding | Def ault (Y/N ) | Applica bility (Foreca st or Non- Forecas t/Rules Based) | Definition | DB Reference / Calculation |
|---|---|---|---|---|
| Curre ncy Attrib ute 1 - 30 | Y | Both | User Defined Attribute of Currency Type | Flex Fact (W_RTL_FLEX_FACT) |
| Date Attrib ute 1 - 15 | Y | Both | User Defined Attribute of Date type | Flex Fact (W_RTL_FLEX_FACT) |
| Num ber Attrib ute 1 - 40 | Y | Both | User Defined Attribute of Number Type | Flex Fact (W_RTL_FLEX_FACT) |
| Perc entag e Attrib ute 1 - 15 | Y | Both | User Defined Attribute of Percentage Type | Flex Fact (W_RTL_FLEX_FACT) |
| Text Attrib ute 1 - 30 | Y | Both | User Defined Attribute of Text Type | Flex Fact (W_RTL_FLEX_FACT) |
| Prod AttrV alue1 | N | Both | Product attributes selected by the user in the user filter. For e.g., Brand | RSE_PROD_ATTR |
| - Prod AttrV alue 5 |
May 15, 2026 Appendix G-8 of G-8
In this guide
- Guide: Lifecycle Pricing Optimization User Guide
- Previous: F Appendix: Promotion and Markdown - Manage Recommendations
- Next: H Appendix: Promotion and Markdown - Review Forecast
Related chapters
- F Appendix: Promotion and Markdown - Manage Recommendations — Lifecycle Pricing Optimization User Guide · shares
ACCEPTED_FLG,AVG_COMPETITOR_PRICE,CHANGED_BY_USER,CURRENT_PRICE - C Appendix: Regular - Manage Recommendations — Lifecycle Pricing Optimization Rule Based Regular Pricing User Guide · shares
AVG_COMPETITOR_PRICE,CHANGED_BY_USER,EXPORTED_BY_USER,EXPORTED_ON_DT - H Appendix: Promotion and Markdown - Review Forecast — Lifecycle Pricing Optimization User Guide · shares
CURRENT_PRICE,HIER_LEVEL_ID,OPTIMAL_FORECASTED_SALES,OPTIMAL_REMAINING_INVENTORY - D Appendix: Innovation Workbench — Lifecycle Pricing Optimization Rule Based Regular Pricing User Guide · shares
PRO_REG_RUN_RECOM_DENORMALIZE,PRO_REG_RUN_RECOM_OPT_RESULT