Oracle Fusion · Data dictionary
MSC_ANALYTIC_ORG_FLAT_V_DYD
SharedUsed in 97 subject areas7 reporting columns
Supply Chain Planning (MSC).
Primary key: not yet catalogued for MSC_ANALYTIC_ORG_FLAT_V_DYD, reference Oracle Tables & Views guide.
Joins (inferred from key columns): ORGANIZATION_ID → INV_ORGANIZATION_DEFINITIONS_V
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| BUSINESS_UNIT | ● | Business unit. | |
| BUSINESS_UNIT_NAME | ● | Name of the business unit. | |
| LEGAL_ENTITY | ● | Legal entity. | |
| LEGAL_ENTITY_NAME | ● | Name of the legal entity. | |
| ORGANIZATION_CODE | ● | Code identifying the organization. | |
| ORGANIZATION_ID | ● | Identifier for the organization. | |
| ORGANIZATION_NAME | ● | Name of the organization. |
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.
- Costing - Cost Accounting Period Close Real Time
- Costing - Cost Accounting Real Time
- Costing - Cost Rollup Details Real Time
- Costing - Landed Costs Real Time
- Costing - New COGS and Gross Margin Details Real Time
- Costing - Overhead Rates Real Time
- Costing - Period Intransit Inventory Valuation Real Time
- Costing - Period Inventory Valuation Real Time
- Costing - Receipt Accounting Period Close Real Time
- Costing - Receipt Accounting Real Time
- Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time
- Costing - Standard Cost Real Time
- Costing - Supply Chain Cost Rollup Real Time
- Costing - Transaction Cost Real Time
- Costing - Where Used Details Real Time
- Costing - Work Order Costs Real Time
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Distributed Order Orchestration - Order Holds Real Time
- Distributed Order Orchestration - Price Adjustments Real Time
- Enterprise Contracts - Contracts Real Time
Need the extract + dbt staging for MSC_ANALYTIC_ORG_FLAT_V_DYD?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table