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: Innovation Workbench
The Innovation Workbench tables follow this convention: the RSE prefix is used for core foundation tables, the PRO prefix is used for Promotion and Markdown Optimization tables, and the PRO_REG prefix is used for Regular Pricing Optimization tables.
For Rules Based Regular Pricing, the following Regular Pricing tables are the most relevant for validation, diagnostics, recommendation review, integration tracking, and reporting. These tables are exposed in read-only mode and can be used to analyze run setup, rule application, generated recommendations, export status, and run failures.
Table D-1 Innovation Workbench Tables for Rules Based Regular Pricing
| Table Name | Use in Rules Based Regular Pricing |
|---|---|
| PRO_REG_RUN_HDR | Contains run-level information such as run ID, run name, run status, strategy, scope, optimization dates, created user, modified user, and execution details. |
| PRO_BATCH_REG_RUN_QUEUE | Contains batch queue information for scheduled Regular Pricing runs. |
| PRO_REG_RUN_PRODUCT | Contains the merchandise or product scope included in the run. |
| PRO_REG_RUN_LOC_PZ | Contains the location or price zone scope included in the run. |
| PRO_REG_RUN_REC_ITEM | Contains item-level recommendation records generated for the run. |
| PRO_REG_RUN_REC_ITEM_DATE | Contains effective date information for item-level regular price recommendations. |
| PRO_REG_RUN_RECOM_OPT_RESULT | Contains optimized Regular Pricing recommendation results, including recommended price, override price where applicable, recommendation status, effective date, and export- related information. |
| PRO_REG_RUN_RECOM_DENORMALIZE | Contains denormalized recommendation information used for reporting and analysis. |
| PRO_REG_RUN_RESULT_METRIC | Contains run result metrics available for Regular Pricing runs. For Rules Based runs, forecast- dependent projected metrics may not be populated. |
| PRO_REG_RUN_SANITY_CHECK_RES | Contains validation, warning, alert, and error information generated for a run. Review this table when a run ends in Failed status or recommendations are not generated as expected. |
| PRO_REG_RUN_PRICERECOM_INT_ERR | Contains integration error information related to regular price recommendation export. |
| PRO_REG_RUN_OPT_RULES | Contains the rules evaluated during optimization for the run. |
| PRO_REG_RUN_OPT_RULES_REC_DTL | Contains item-level rule evaluation details for generated recommendations. |
Rules Based Regular Pricing User Guide G58167-03 Copyright© 2026, Oracle and/or its affiliates.
July 27, 2026 Appendix D-1 of D-2
Appendix D
Table D-1 (Cont.) Innovation Workbench Tables for Rules Based Regular Pricing
| Table Name | Use in Rules Based Regular Pricing |
|---|---|
| PRO_REG_RUN_OPT_RULES_RELAX | Contains relaxed or violated rule information when the best feasible recommendation is generated. |
| PRO_REG_OPT_RULES_BAD | Contains rule validation issues identified before or during optimization. |
| PRO_REG_RUN_PRICE_LADDER | Contains price ladder information applied during the run. |
| PRO_REG_RUN_PRICE_MATRIX | Contains price matrix information applied during the run. |
| PRO_REG_PRICE_MATRIX_HDR | Contains price matrix header setup information. |
| PRO_REG_PRICE_MATRIX_DTL | Contains price matrix detail setup information. |
| PRO_REG_PRICE_MATRIX_BAD | Contains price matrix validation issues. |
| PRO_REG_COMP_PRICE | Contains competitor price information used by competitor-based Non-Forecast rules. |
| PRO_REG_PRICE_COST | Contains price and cost information used by margin, cost change, and price range rules. |
| PRO_REG_PROD_PACK | Contains pack item information used when pack pricing rules are applicable. |
| PRO_REG_RUN_PCM_OVRD | Contains run-level override information used when recommendation prices are overridden. |
| PRO_REG_RUN_ORULE_REC_PR_RANGE | Contains optimized rule recommendation price range information used during rule evaluation. |
| PRO_REG_PROD_LOC_CDA | Contains product-location custom data attributes that can support reporting and analysis. |
| PRO_REG_RUN_REC_PROD_LOC_CDA | Contains run-level product-location custom data attributes associated with generated recommendations. |
| PRO_REG_BASE_PERIOD, PRO_REG_RUN_FCST, PRO_REG_INVENTORY, PRO_REG_PRICING_OBJECTIVE | These tables are primarily associated with Forecast-Based Regular Pricing and are generally not required for Rules Based Regular Pricing analysis. |
Rules Based Regular Pricing User Guide G58167-03 Copyright© 2026, Oracle and/or its affiliates.
July 27, 2026 Appendix D-2 of D-2
In this guide
- Guide: Lifecycle Pricing Optimization Rule Based Regular Pricing User Guide
- Previous: C Appendix: Regular - Manage Recommendations
Related chapters
- 8 Innovation Workbench — Lifecycle Pricing Optimization User Guide · shares
PRO_REG,PRO_REG_RUN_RECOM_OPT_RESULT - G Appendix: Regular - Manage Recommendations — Lifecycle Pricing Optimization User Guide · shares
PRO_REG_RUN_RECOM_DENORMALIZE,PRO_REG_RUN_RECOM_OPT_RESULT