Oracle Fusion · Data dictionary
MSC_ANALYTIC_FACT_DM_V
SharedUsed in 1 subject areas12 reporting columns
Supply Chain Planning (MSC) — denormalized view.
Primary key: not yet catalogued for MSC_ANALYTIC_FACT_DM_V — reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| BOOK_FCST | ● | Book fcst. | |
| BOOK_HISTORY | ● | Book history. | |
| BOOK_HISTORY_VALUE | ● | Book history value. | |
| DEMAND_DATE | ● | Demand date. | |
| FINAL_BOOK_FCST | ● | Final book fcst. | |
| FINAL_CONS_FCST | ● | Final cons fcst. | |
| FINAL_CONS_HISTORY | ● | Final cons history. | |
| FINAL_SHIP_FCST | ● | Final shipment fcst. | |
| SHIP_FCST | ● | Shipment fcst. | |
| SHIP_FCST_VALUE | ● | Shipment fcst value. | |
| SHIP_HISTORY | ● | Shipment history. | |
| SHIP_HISTORY_VALUE | ● | Shipment history value. |
Used by reports
No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.
- —
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.
Need the extract + dbt staging for MSC_ANALYTIC_FACT_DM_V?
We ship parameterized SQL, BICC config, and dbt models you own.