Oracle Fusion · OTBI subject area
Supply Chain Planning Real Time
Free reference33 tables286 columnsSCM & Procurement
This is the OTBI subject area you select in Reports & Analytics to report on supply chain planning real time data. It exposes the presentation columns mapped to the physical tables below, and corresponds to the — module.
OTBI limitation: you can't join two subject areas in a single analysis, and real-time queries hit the live transaction tables. The customer-owned warehouse removes both limits — every subject area is conformed on shared keys so you can join across them, and reporting runs off the warehouse, not production.
Physical tables in this subject area
- EGP_ITEM_CATEGORIES
- EGP_SYSTEM_ITEMS_B_V
- FND_CAL_DAY
- FND_LOOKUP_VALUES_TL
- FUN_ALL_BUSINESS_UNITS_V
- HZ_PARTIES
- HZ_PARTY_SITES
- INV_ITEM_LOCATIONS
- INV_ORG_PARAMETERS
- INV_SECONDARY_INVENTORIES_VL
- MSC_ANALYTIC_CALENDARS_V
- MSC_ANALYTIC_CUST_FLAT_V_DYD
- MSC_ANALYTIC_END_DEMANDS
- MSC_ANALYTIC_FACT_CTO_V
- MSC_ANALYTIC_FACT_DM_V
- MSC_ANALYTIC_FACT_EXP
- MSC_ANALYTIC_FACT_INV_REPL_V
- MSC_ANALYTIC_FACT_ORD_V
- MSC_ANALYTIC_FACT_PEG_V
- MSC_ANALYTIC_FACT_SOP_V
- MSC_ANALYTIC_ITEMS
- MSC_ANALYTIC_ORG_FLAT_V_DYD
- MSC_ANALYTIC_PRIVATE_PLAN_V
- MSC_ANALYTIC_RES_FLAT_V_DYD
- MSC_ANALYTIC_SUP_FLAT_V_DYD
- MSC_EXCEPTION_VL
- MSC_SR_LOOKUP_VALUES_TL
- POZ_SUPPLIERS
- POZ_SUPPLIER_SITES_ALL_M
- WIS_RESOURCES_B
- WIS_RESOURCES_TL
- XLE_ENTITY_PROFILES
- ZCA_BI_CRM_CALENDAR
Need to join Supply Chain Planning Real Time across other subject areas?
That's the warehouse build — conformed dimensions, reconciled to source, you own it.