Oracle Fusion · Data dictionary
MSC_ANALYTIC_CALENDARS_V
SharedUsed in 114 subject areas14 reporting columns
Supply Chain Planning (MSC), denormalized view.
Primary key: not yet catalogued for MSC_ANALYTIC_CALENDARS_V, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CALENDAR_CODE | ● | Code identifying the calendar. | |
| CALENDAR_DATE | ● | Calendar date. | |
| CALENDAR_NAME | ● | Name of the calendar. | |
| MONTH | ● | Month. | |
| MONTH_END_DATE | ● | Month end date. | |
| MONTH_START_DATE | ● | Month start date. | |
| PERIOD_START_DATE | ● | Period start date. | |
| QUARTER | ● | Quarter. | |
| QUARTER_END_DATE | ● | Quarter end date. | |
| QUARTER_START_DATE | ● | Quarter start date. | |
| WEEK_START_DATE | ● | Week start date. | |
| YEAR | ● | Year. | |
| YEAR_END_DATE | ● | Year end date. | |
| YEAR_START_DATE | ● | Year start date. |
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 Real Time
- Costing - Landed Costs Real Time
- Costing - New COGS and Gross Margin Details Real Time
- Costing - Period Inventory Valuation Real Time
- Costing - Periodic Average Cost Real Time
- Costing - Perpetual Average Cost Real Time
- Costing - Receipt Accounting Real Time
- Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time
- Costing - Standard Cost Real Time
- Costing - Transaction Cost Real Time
- Costing - Transfer Order Receipt Landed Cost Charges Real Time
- Costing - Work Order Costs Real Time
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Distributed Order Orchestration - Order Headers Real Time
- Distributed Order Orchestration - Order Holds Real Time
- Distributed Order Orchestration - Order Lines Real Time
- Distributed Order Orchestration - Price Adjustments Real Time
- Distributed Order Orchestration - Process Instances Real Time
- Enterprise Contracts - Contracts Real Time
- Enterprise Quality Actions Real Time
Need the extract + dbt staging for MSC_ANALYTIC_CALENDARS_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table