OPI — Operations Intelligence (Obsolete)
34 documented tables · 37 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
EDW_OPI_LOTD_LOT_LTC |
Level Table for the LOT level of the LOTD (Lot Dimension) | standalone |
EDW_MTL_ILDM_OU_LTC |
Level Table for the OU (Operating Unit) level of the ILDM (Inventory Locator Dimension) | standalone |
OPI_IDS_PUSH_DATE_LOG |
standalone | |
OPI_EDW_JOB_DETAIL_F |
Job Detail fact will store the detail information of the Jobs/Batches. There will be one row for each jobs and | standalone |
OPI_EDW_INV_DAILY_STAT_F |
Fact Table for the Inventory Daily Status Fact | standalone |
EDW_MTL_ILDM_PLANT_LTC |
Level Table for the Inventory Org level of the ILDM (Inventory Locator Dimension) | standalone |
OPI_EDW_RES_UTIL_F |
This is resource utilization fact table. Resource utilization is a measure indicating how much your resources | standalone |
EDW_MTL_ILDM_LOCATOR_LTC |
Level Table for the LOCATOR level of the ILDM (Inventory Locator Dimension) | standalone |
OPI_PMI_IDS_TEMP |
standalone | |
EDW_MTL_INVENTORY_LOC_M |
Dimension Table for the(Inventory Locator Dimension | standalone |
EDW_OPI_LOT_M |
Dimension Table for the LOT Dimension | standalone |
EDW_MTL_ILDM_PCMP_LTC |
Level Table for the PCMP (Process Company) level of the ILDM (Inventory Locator Dimension) | standalone |
EDW_MTL_INVENTORY_LOC_A_LTC |
Level Table for the A (All) level of the (Inventory Locator Dimension | standalone |
OPI_IDS_PUSH_LOG |
standalone | |
EDW_MTL_UOM_M |
Unit Of Measure dimension | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.