Table: EDW_OPI_PRDL_M | Oracle EBS ETRM Search

Table: EDW_OPI_PRDL_M 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·18 columns

Dimension table for Production Line that is used in Production Analysis. In Discrete Mfg., Assembly lines can be treated as production lines. As of now Process manufacturing does not have any concept of Production line.

OPI.EDW_OPI_PRDL_M·Explore OPI module →

Table: EDW_POA_SPLRITEM_M 12.1.1

owner POA·POA - Purchasing Intelligence·18 columns

Supplier Item dimension table

POA.EDW_POA_SPLRITEM_M·Explore POA module →

Table: EDW_PA_EXP_TYPE_M 12.1.1

owner FII·FII - Financial Intelligence·15 columns

Project Expenditure Type dimension

FII.EDW_PA_EXP_TYPE_M·Explore FII module →

Table: EDW_BIM_IH_REASN_M 12.1.1 hub-leaning

owner BIM·BIM - Marketing Intelligence·21 columns

Interaction Reason Dimension table .

BIM.EDW_BIM_IH_REASN_M·Explore BIM module →

Table: EDW_BIM_IH_RESLT_M 12.2.2 hub-leaning

owner BIM·BIM - Marketing Intelligence(Obsolete)·22 columns

Interaction Result Dimension table .

BIM.EDW_BIM_IH_RESLT_M·Explore BIM module →

Table: EDW_BIM_IH_MEDIA_M 12.1.1 hub-leaning

owner BIM·BIM - Marketing Intelligence·22 columns

Interaction Media Dimension Table .

BIM.EDW_BIM_IH_MEDIA_M·Explore BIM module →

Table: EDW_HR_REASON_M 12.1.1 standalone

owner HRI·HRI - Human Resources Intelligence·21 columns

HRI.EDW_HR_REASON_M·Explore HRI module →

Table: EDW_BIM_IH_MEDIA_M 12.2.2 hub-leaning

owner BIM·BIM - Marketing Intelligence(Obsolete)·22 columns

Interaction Media Dimension Table .

BIM.EDW_BIM_IH_MEDIA_M·Explore BIM module →

Table: EDW_BIM_IH_OUTCM_M 12.1.1 hub-leaning

owner BIM·BIM - Marketing Intelligence·22 columns

Interaction Outcome Dimension .

BIM.EDW_BIM_IH_OUTCM_M·Explore BIM module →

Table: EDW_BIM_IH_RESLT_M 12.1.1 hub-leaning

owner BIM·BIM - Marketing Intelligence·22 columns

Interaction Result Dimension table .

BIM.EDW_BIM_IH_RESLT_M·Explore BIM module →

Table: EDW_OPI_PRDL_M 12.2.2

owner OPI·OPI - Operations Intelligence (Obsolete)·18 columns

Dimension table for Production Line that is used in Production Analysis. In Discrete Mfg., Assembly lines can be treated as production lines. As of now Process manufacturing does not have any concept of Production line.

OPI.EDW_OPI_PRDL_M·Explore OPI module →

Table: EDW_MTL_UOM_M 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·19 columns

Unit Of Measure dimension

OPI.EDW_MTL_UOM_M·Explore OPI module →

Table: EDW_HR_SERVICE_M 12.1.1 standalone

owner HRI·HRI - Human Resources Intelligence·25 columns

HRI.EDW_HR_SERVICE_M·Explore HRI module →

Table: EDW_CURRENCY_M 12.1.1

owner FII·FII - Financial Intelligence·26 columns

Currency dimension table.

FII.EDW_CURRENCY_M·Explore FII module →

Table: EDW_OPI_OPRN_M 12.2.2

owner OPI·OPI - Operations Intelligence (Obsolete)·29 columns

Operations Dimension Table

OPI.EDW_OPI_OPRN_M·Explore OPI module →

Table: EDW_OPI_LOT_M 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·23 columns

Dimension Table for the LOT Dimension

OPI.EDW_OPI_LOT_M·Explore OPI module →

Table: EDW_HR_ASG_CHNG_M 12.1.1 standalone

owner HRI·HRI - Human Resources Intelligence·25 columns

HRI.EDW_HR_ASG_CHNG_M·Explore HRI module →

Table: EDW_HR_POSITION_M 12.1.1 standalone

owner HRI·HRI - Human Resources Intelligence·31 columns

HRI.EDW_HR_POSITION_M·Explore HRI module →

Table: EDW_AR_DOC_NUM_M 12.1.1 standalone

owner FII·FII - Financial Intelligence·28 columns

Receivables Document Number dimension table

FII.EDW_AR_DOC_NUM_M·Explore FII module →

Table: EDW_OPI_OPRN_M 12.1.1

owner OPI·OPI - Operations Intelligence·29 columns

Operations Dimension Table

OPI.EDW_OPI_OPRN_M·Explore OPI module →

Table: EDW_MTL_UOM_M 12.2.2 standalone

owner OPI·OPI - Operations Intelligence (Obsolete)·19 columns

Unit Of Measure dimension

OPI.EDW_MTL_UOM_M·Explore OPI module →

Table: EDW_BIM_IH_REASN_M 12.2.2 hub-leaning

owner BIM·BIM - Marketing Intelligence(Obsolete)·21 columns

Interaction Reason Dimension table .

BIM.EDW_BIM_IH_REASN_M·Explore BIM module →

Table: EDW_BIM_IH_OUTCM_M 12.2.2 hub-leaning

owner BIM·BIM - Marketing Intelligence(Obsolete)·22 columns

Interaction Outcome Dimension .

BIM.EDW_BIM_IH_OUTCM_M·Explore BIM module →

Table: EDW_HR_RQN_VCNCY_M 12.1.1 standalone

owner HRI·HRI - Human Resources Intelligence·44 columns

HRI.EDW_HR_RQN_VCNCY_M·Explore HRI module →

Table: EDW_OPI_LOT_M 12.2.2 standalone

owner OPI·OPI - Operations Intelligence (Obsolete)·23 columns

Dimension Table for the LOT Dimension

OPI.EDW_OPI_LOT_M·Explore OPI module →

Table: EDW_OPI_ACTV_M 12.2.2

owner OPI·OPI - Operations Intelligence (Obsolete)·19 columns

Activity Dimensiom contains all the Activities of Discrete and Process Manufacturing.

OPI.EDW_OPI_ACTV_M·Explore OPI module →

Table: EDW_OPI_ACTV_M 12.1.1

owner OPI·OPI - Operations Intelligence·19 columns

Activity Dimensiom contains all the Activities of Discrete and Process Manufacturing.

OPI.EDW_OPI_ACTV_M·Explore OPI module →

Table: EDW_POA_LN_TYPE_M 12.1.1

owner POA·POA - Purchasing Intelligence·19 columns

PO Line Type dimension table

POA.EDW_POA_LN_TYPE_M·Explore POA module →

Table: EDW_HR_ASSGNMNT_M 12.1.1 standalone

owner HRI·HRI - Human Resources Intelligence·43 columns

HRI.EDW_HR_ASSGNMNT_M·Explore HRI module →

Table: EDW_REV_SOURCE_M 12.1.1 standalone

owner FII·FII - Financial Intelligence·29 columns

Revenue Source dimension

FII.EDW_REV_SOURCE_M·Explore FII module →

Table: EDW_LOOKUP_M 12.1.1 standalone

owner POA·BIS - Applications BIS·21 columns

POA.EDW_LOOKUP_M·Explore BIS module →

Table: EDW_LOOKUP_M 12.1.1 standalone

owner POA·POA - Purchasing Intelligence·21 columns

Lookup dimension table

POA.EDW_LOOKUP_M·Explore POA module →

Table: EDW_AP_PAY_TERM_M 12.1.1

owner FII·FII - Financial Intelligence·21 columns

This is payment term dimension table. This is a denormalized star table and contains records for lowest level of the dimension and their parentage up to the top level.

FII.EDW_AP_PAY_TERM_M·Explore FII module →

Table: EDW_UNSPSC_M 12.1.1

owner POA·POA - Purchasing Intelligence·62 columns

UNSPSC dimension table

POA.EDW_UNSPSC_M·Explore POA module →

Table: EDW_HR_AGE_BAND_M 12.1.1 standalone

owner HRI·HRI - Human Resources Intelligence·23 columns

HRI.EDW_HR_AGE_BAND_M·Explore HRI module →

Table: EDW_HR_GRADE_M 12.1.1 standalone

owner HRI·HRI - Human Resources Intelligence·24 columns

HRI.EDW_HR_GRADE_M·Explore HRI module →

Table: EDW_SIC_CODE_M 12.1.1 standalone