Table: OPI_EDW_IDS_NET_CHG | Oracle EBS ETRM Search

Table: OPI_EDW_IDS_NET_CHG 12.1.1

owner OPI·OPI - Operations Intelligence·11 columns

OPI.OPI_EDW_IDS_NET_CHG·Explore OPI module →

Table: OPI_EDW_RES_UTIL_F 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·38 columns

This is resource utilization fact table. Resource utilization is a measure indicating how much your resources are used in production.It is a comparison of the resource time used and the total resource available.The Resource Utilization fact

OPI.OPI_EDW_RES_UTIL_F·Explore OPI module →

Table: OPI_EDW_JOB_RSRC_FSTG 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·84 columns

Interface table for the Job Resource Fact. This will be the staging area for data coming into the Warehouse from Discrete and Process Manufacturing sources.

OPI.OPI_EDW_JOB_RSRC_FSTG·Explore OPI module →

Table: OPI_EDW_INV_PERD_STAT_F 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·97 columns

Fact Table for the Inventory Period Status Derived Fact

OPI.OPI_EDW_INV_PERD_STAT_F·Explore OPI module →

Table: OPI_EDW_COGS_F 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·101 columns

COGS Shipment Fact table

OPI.OPI_EDW_COGS_F·Explore OPI module →

Table: OPI_EDW_INV_DAILY_STAT_F 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·102 columns

Fact Table for the Inventory Daily Status Fact

OPI.OPI_EDW_INV_DAILY_STAT_F·Explore OPI module →

Table: OPI_EDW_IPS_NET_CHG 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·99 columns

OPI.OPI_EDW_IPS_NET_CHG·Explore OPI module →

Table: OPI_EDW_JOB_DETAIL_F 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·89 columns

Job Detail fact will store the detail information of the Jobs/Batches. There will be one row for each jobs and each end products. For example, if a batch produces two products ( one main product and one co-product) then the fact table will

OPI.OPI_EDW_JOB_DETAIL_F·Explore OPI module →

Table: OPI_EDW_RES_UTIL_FSTG 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·54 columns

This is the interface table for Resource Utilization Fact. Data from multiple transactional systems is staged here for verification and cleansing before being loaded into the fact table.

OPI.OPI_EDW_RES_UTIL_FSTG·Explore OPI module →

Table: POA_EDW_RCV_TXNS_F 12.1.1

owner POA·POA - Purchasing Intelligence·94 columns

Receiving fact

POA.POA_EDW_RCV_TXNS_F·Explore POA module →

Table: OPI_EDW_JOB_RSRC_F 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·63 columns

This is the Job Resource Fact. It contains detailed information regarding resources used in Jobs/Batches. It will contain usage, value and count information for resources. It will also contain quantities produced by resources and the assoc

OPI.OPI_EDW_JOB_RSRC_F·Explore OPI module →

Table: OPI_EDW_COGS_FSTG 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·152 columns

Interface table for COGS Shipment Fact

OPI.OPI_EDW_COGS_FSTG·Explore OPI module →

Table: OPI_EDW_JOB_DETAIL_FSTG 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·109 columns

Job Detail Fact Staging Table Sourced from the Fllowing Views OPI_EDW_OPM_JOB_DETAIL_FCV and OPI_EDW_OPI_JOB_DETAILS_FCV

OPI.OPI_EDW_JOB_DETAIL_FSTG·Explore OPI module →

Table: OPI_EDW_INV_DAILY_STAT_F_DLOG 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·117 columns

Fact Delete log Table for the Inventory Daily Status Fact