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.
B
Appendix: Regular - Run Overview
This table provides information about table columns and calculations for Regular Optimization runs.
Table B-1 B-1 Column Details
| Column Heading | Default | Definition | DB Reference / Calculation |
|---|---|---|---|
| Run Id | Y | System-generated unique identifier for the run. | RUN_HDR_ID |
| Finalized | Y | Flag indicating that recommendations from the run are finalized and used in Manage Recommendations. | FINALIZED_FLG |
| Run Name | Y | User provided name for the run. | RUN_NAME |
| Run Description | Y | User provided description for the run. | RUN_DESCR |
| Department | Y | A description of the Department. | CONCAT(PROD_HIER_ EXT_CODE, ’-‘, PROD_HIER_NAME) |
| Price Zone Group | Y | Price zone group of the item recommendation. Corresponds to the run setup level. | CONCAT(PRICE_ZONE _GRP_EXT_CODE, ’-‘, PRICE_ZONE_GRP_N AME) |
| Price Zone | Y | Price zone of the item recommendation. Corresponds to the run setup level. | CONCAT(PRICE_ZONE _EXT_CODE, ’+‘, PRICE_ZONE_NAME) |
| Company | Y | Location of the item recommendation, such as Region or Channel. Will be chain when using price zones. | CONCAT(LOC_HIER_E XT_CODE, ’+‘, LOC_HIER_NAME) |
| Opt Start Dt | Y | The start date of optimization. | START_CAL_FROM_DT |
| Opt End Dt | Y | The end date of optimization. | END_CAL_TO_DT |
| Strategy | Y | The strategy used for optimization. It can be DEFAULT STRATEGY or another custom strategy. | RULE_SET_NAME |
| Total Item Cnt | Y | Total item count. | ITEM_OPTIMIZED_CO UNT |
Rules Based Regular Pricing User Guide G58167-03 Copyright© 2026, Oracle and/or its affiliates.
July 27, 2026 Appendix B-1 of B-2
Appendix B
Table B-1 (Cont.) B-1 Column Details
| Column Heading | Default | Definition | DB Reference / Calculation |
|---|---|---|---|
| Non-fcst Item Cnt | Y | Number of non-forecast item recommendations included in the run. | NON_FCST_ITEM_CNT |
| No Rec Item Cnt | Y | Total items that are in No Recommendation status. | ITEM_NOREC_COUNT |
| Reg Item Cnt | Y | Regular items count. | ITEM_REGULAR_COU NT |
| User Ovrd Item Cnt | Y | Total items that are overridden by user. | ITEM_USR_OVRD_CO UNT |
| Run Status | Y | Status of the run. | RUN_STATUS_DESCR |
| Optimized On | Y | The date when the run was optimized. | LAST_EXECUTION_DA TE |
| 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 |
Rules Based Regular Pricing User Guide G58167-03 Copyright© 2026, Oracle and/or its affiliates.
July 27, 2026 Appendix B-2 of B-2
In this guide
- Guide: Lifecycle Pricing Optimization Rule Based Regular Pricing User Guide
- Previous: A Appendix: Regular Pricing Optimization Rules
- Next: C Appendix: Regular - Manage Recommendations
Related chapters
- E Appendix: Regular - Run Overview — Lifecycle Pricing Optimization User Guide · shares
CHANGED_BY_USER,CREATED_BY_USER,CREATED_ON_DT,END_CAL_TO_DT - D Appendix: Promotion and Markdown - Run Overview — Lifecycle Pricing Optimization User Guide · shares
CHANGED_BY_USER,CREATED_BY_USER,CREATED_ON_DT,FINALIZED_FLG