You are browsing the archive for Oracle Operations Intelligence.

Load Lot Dimension

 

NAME: Load Lot Dimension
SHORT CODE: COLLECT_EDW_OPI_LOT_M
MODULE: Oracle Operations Intelligence

Description: Load Lot Dimension
Navigation: Oracle Operations Intelligence Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_dim_name : Dimension Name

 

Operations Intelligence Tables

Oracle Operations Intelligence Tables:

  • EDW_MTL_ILDM_LOCATOR_LSTG
  • EDW_MTL_ILDM_LOCATOR_LTC
  • EDW_MTL_ILDM_OU_LSTG
  • EDW_MTL_ILDM_OU_LTC
  • EDW_MTL_ILDM_PCMP_LSTG
  • EDW_MTL_ILDM_PCMP_LTC
  • EDW_MTL_ILDM_PLANT_LSTG
  • EDW_MTL_ILDM_PLANT_LTC
  • EDW_MTL_ILDM_PORG_LSTG
  • EDW_MTL_ILDM_PORG_LTC
  • EDW_MTL_ILDM_SUB_INV_LSTG
  • EDW_MTL_ILDM_SUB_INV_LTC
  • EDW_MTL_INVENTORY_LOC_A_LTC
  • EDW_MTL_INVENTORY_LOC_M
  • EDW_MTL_LOCAL_UOM_M
  • EDW_MTL_UOMD_UOM_LSTG
  • EDW_MTL_UOMD_UOM_LTC
  • EDW_MTL_UOM_A_LTC
  • EDW_MTL_UOM_M
  • EDW_OPI_ACTV_ACTV_LSTG
  • EDW_OPI_ACTV_ACTV_LTC
  • EDW_OPI_ACTV_A_LTC
  • EDW_OPI_ACTV_M
  • EDW_OPI_LOTD_LOT_LSTG
  • EDW_OPI_LOTD_LOT_LTC
  • EDW_OPI_LOT_A_LTC
  • EDW_OPI_LOT_M
  • EDW_OPI_OPRN_A_LTC
  • EDW_OPI_OPRN_M
  • EDW_OPI_OPRN_OPRC_LSTG
  • EDW_OPI_OPRN_OPRC_LTC
  • EDW_OPI_OPRN_OPRN_LSTG
  • EDW_OPI_OPRN_OPRN_LTC
  • EDW_OPI_PRDL_A_LTC
  • EDW_OPI_PRDL_M
  • EDW_OPI_PRDL_PRDL_LSTG
  • EDW_OPI_PRDL_PRDL_LTC
  • OPI_DBI_PTP_PLAN_STG
  • OPI_DBI_WMS_TASKS_STG
  • OPI_EDW_COGS_F
  • OPI_EDW_COGS_FSTG
  • OPI_EDW_COGS_F_DLOG
  • OPI_EDW_COGS_INC
  • OPI_EDW_COGS_LOG
  • OPI_EDW_IDS_NET_CHG
  • OPI_EDW_IDS_OPICOLLB_LOG
  • OPI_EDW_INV_DAILY_STAT_F
  • OPI_EDW_INV_DAILY_STAT_FSTG
  • OPI_EDW_INV_DAILY_STAT_F_DLOG
  • OPI_EDW_INV_PERD_STAT_F
  • OPI_EDW_IPS_NET_CHG
  • OPI_EDW_JOB_DETAIL_F
  • OPI_EDW_JOB_DETAIL_FSTG
  • OPI_EDW_JOB_RSRC_F
  • OPI_EDW_JOB_RSRC_FSTG
  • OPI_EDW_LOCAL_UOM_CONV_F
  • OPI_EDW_MARGIN_COGS_ILOG
  • OPI_EDW_MARGIN_F
  • OPI_EDW_MARGIN_PERD_FD
  • OPI_EDW_MARGIN_PERD_FDLG
  • OPI_EDW_MARGIN_PERD_FIR
  • OPI_EDW_MARGIN_PERD_ILOG
  • OPI_EDW_MRG_KEYS
  • OPI_EDW_MRG_MAX_VALUES
  • OPI_EDW_OPI_JOB_DETAIL_INC
  • OPI_EDW_OPI_JOB_RSRC_INC
  • OPI_EDW_OPI_JOB_RSRC_MR_TMP
  • OPI_EDW_OPMCOGS_INC
  • OPI_EDW_OPM_JOB_DETAIL_INC
  • OPI_EDW_OPM_JOB_RSRC_INC
  • OPI_EDW_PERD_MARGIN_F
  • OPI_EDW_PERD_MARGIN_FT
  • OPI_EDW_PERD_MARGIN_FUR
  • OPI_EDW_RES_UTIL_F
  • OPI_EDW_RES_UTIL_FSTG
  • OPI_EDW_RES_UTIL_PUSH_LOG
  • OPI_EDW_REV_LOG
  • OPI_EDW_UOM_CONV_F
  • OPI_EDW_UOM_CONV_FSTG
  • OPI_IDS_PUSH_DATE_LOG
  • OPI_IDS_PUSH_LOG
  • OPI_PMI_DAY_SUM_TEMP
  • OPI_PMI_IDS_IDNT
  • OPI_PMI_IDS_SUM_LOG
  • OPI_PMI_IDS_TEMP
  • OPI_PMI_INV_DAILY_STAT_SUM
  • OPI_PMI_INV_DAILY_STAT_TEMP
  • OPI_PMI_TRANS_INC

Views in Operations Intelligence Module

List of Views in Oracle Operations Intelligence Module

OPI_EDW_COGS_FCV
OPI_EDW_EXP_INV_VAL_PERD_V
OPI_EDW_INV_QTY_PERD_V
OPI_EDW_INV_TURNS_PERD_V
OPI_EDW_INV_TURNS_QTR_V
OPI_EDW_INV_TURNS_YR_V
OPI_EDW_INV_VALUE_PERD_V
OPI_EDW_JOB_DETAIL_V
OPI_EDW_OPI_JOB_DETAIL_FCV
OPI_EDW_OPI_JOB_RSRC_FCV
OPI_EDW_OPI_RES_UTIL_FCV
OPI_EDW_OPIINV_DAILY_STAT_FCV
OPI_EDW_OPM_JOB_DETAIL_FCV
OPI_EDW_OPM_JOB_RSRC_FCV
OPI_EDW_OPM_RES_UTIL_FCV
OPI_EDW_OPMCOGS_FCV
OPI_EDW_OPMINV_DAILY_STAT_FCV
OPI_EDW_PRODUCT_GROSS_MARGIN_V
OPI_EDW_PRODUCT_SALES_REV_V
OPI_EDW_RSRC_EFFICIENCY_V
OPI_EDW_RSRC_UTIL_V
OPI_EDW_TIME_CAL_PERIOD_LTC_V
OPI_EDW_TIME_CAL_PERIOD_V
OPI_EDW_TIME_CAL_QTR_LTC_V
OPI_EDW_TIME_CAL_QTR_V
OPI_EDW_TIME_CAL_YEAR_LTC_V
OPI_EDW_TIME_CAL_YEAR_V
OPI_EDW_UOM_CONV_FCV
OPI_INV_CC_CLS_V
OPI_INV_CC_LVL_V
OPI_INV_ITEM_GRADE_LVL_V
OPI_INV_ITEM_LOT_LVL_V
OPI_INV_UNSEC_ORGANIZATIONS_V
OPI_LOCATORS_V
OPI_MFG_MTL_TRX_REASONS_LVL_V
OPI_MFG_WO_STATUS_LVL_V
OPI_OPM_GL_CALENDAR_V
OPI_PMI_UOMS_MST_V
OPI_SUBINVENTORIES_V
OPI_TIME_STRUCTURES_ITD_V
OPI_WMS_OP_PLAN_NAME_LVL_V
OPI_WMS_TASK_EXC_REASONS_LVL_V