You are browsing the archive for Oracle Supply Chain Intelligence.

by oracleguru

Collect Backlog Fact

ORACLE APPS COMMUNITY > Tutorial > Business Intelligence > Oracle Supply Chain Intelligence

 

NAME: Collect Backlog Fact
SHORT CODE: ISC_EDW_BACKLOGS_F
MODULE: Oracle Supply Chain Intelligence

Description: Collect Backlog Fact
Navigation: Oracle Supply Chain Intelligence Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_from_date : Collect From Date
  • p_to_date : Collect To Date
  • p_coll_flag : Collect only if ALL rows have valid conversion rates (Uom and Currency)

 

No Comments »

by oracleguru

Oracle Supply Chain Intelligence Tables

ORACLE APPS COMMUNITY > Tutorial > Business Intelligence > Oracle Supply Chain Intelligence

Oracle supply chain intelligence module – List of database tables

  • EDW_MRP_DCDM_DM_LSTG
  • EDW_MRP_DCDM_DM_LTC
  • EDW_MRP_DM_CLS_A_LTC
  • EDW_MRP_DM_CLS_M
  • EDW_MRP_FCDM_FCS_LSTG
  • EDW_MRP_FCDM_FCS_LTC
  • EDW_MRP_FCDM_SET_LSTG
  • EDW_MRP_FCDM_SET_LTC
  • EDW_MRP_FORECAST_M
  • EDW_MRP_PLAN_M
  • EDW_MRP_PNDM_PLN_LSTG
  • EDW_MRP_PNDM_PLN_LTC
  • EDW_OE_SCHN_SCHN_LSTG
  • EDW_OE_SCHN_SCHN_LTC
  • EDW_OE_SLCHNL_A_LTC
  • EDW_OE_SLCHNL_M
  • ISC_DBI_CFM_008_MV
  • ISC_DBI_CFM_012_MV
  • ISC_DBI_CPM_001_MV
  • ISC_DBI_CPM_002_MV
  • ISC_DBI_CPM_003_MV
  • ISC_DBI_CPM_004_MV
  • ISC_DBI_CPM_005_MV
  • ISC_DBI_DEMANDS_F
  • ISC_DBI_EXCEPTION_DETAILS_F
  • ISC_DBI_FM_0001_MV
  • ISC_DBI_FM_0003_MV
  • ISC_DBI_FM_0006_MV
  • ISC_DBI_FM_0007_MV
  • ISC_DBI_FM_0008_MV
  • ISC_DBI_FULL_PEGGING_F
  • ISC_DBI_INV_DETAIL_F
  • ISC_DBI_INV_DETAIL_SNAPSHOTS
  • ISC_DBI_PM_0000_MV
  • ISC_DBI_PM_0001_MV
  • ISC_DBI_PM_0002_MV
  • ISC_DBI_PM_0003_MV
  • ISC_DBI_PM_0004_MV
  • ISC_DBI_RES_SUMMARY_F
  • ISC_DBI_RES_SUM_SNAPSHOTS
  • ISC_DBI_SHORTFALL_SNAPSHOTS
  • ISC_DBI_SUPPLIES_F
  • ISC_DBI_SUPPLIES_SNAPSHOTS
  • ISC_EDW_BACKLOGS_F
  • ISC_EDW_BACKLOGS_FSTG
  • ISC_EDW_BOOKINGS_F
  • ISC_EDW_BOOKINGS_FSTG
  • ISC_EDW_BOOKINGS_F_DLOG
  • ISC_EDW_BOOK_SUM1_F
  • ISC_EDW_BOOK_SUM1_FSTG
  • ISC_TMP_BACK
  • ISC_TMP_BOOK_SUM1
  • ISC_TMP_PK

Tags: No Comments »

by oracleguru

Views in Supply Chain Intelligence Module

ORACLE APPS COMMUNITY > Tutorial > Business Intelligence > Oracle Supply Chain Intelligence

List of Views in Oracle Supply Chain Intelligence Module

ISC_AGREEMENT_TYPE_V
ISC_BOOK_SUM2_F_V
ISC_CARRIER_SERVICE_LEVEL_V
ISC_DR_MRGN_01_V
ISC_DR_MRGN_02_V
ISC_EDW_BACKLOG_S
ISC_EDW_BACKLOGS_F_FCV
ISC_EDW_BOOK_FULFILL_CYCLE_S
ISC_EDW_BOOK_SUM1_F_FCV
ISC_EDW_BOOK_TO_SHIP_CYCLE_S
ISC_EDW_BOOKINGS_BILLINGS_S
ISC_EDW_BOOKINGS_F_FCV
ISC_EDW_ORD_RECV_PAY_CYCLE_S
ISC_EDW_ORDER_ENTRY_S
ISC_EDW_ORDER_FULFILL_SHIP_S
ISC_EDW_ORDER_FULFILL_VOLUME_S
ISC_EDW_ORDER_SHIP_VOLUME_S
ISC_EDW_PICK_TO_SHIP_CYCLE_S
ISC_EDW_RECEIVE_PAY_CYCLE_S
ISC_FREIGHT_CARRIER_V
ISC_MSC_BIS_CATEGORIES_V
ISC_MSC_BIS_CATEGORY_SETS_V
ISC_MSC_BIS_COMPONENTS_V
ISC_MSC_BIS_CUSTOMERS_V
ISC_MSC_BIS_DEMAND_CLASSES_V
ISC_MSC_BIS_INV_ORGS_V
ISC_MSC_BIS_ITEMS_V
ISC_MSC_BIS_ORGANIZATIONS_V
ISC_MSC_BIS_PERIODS_V
ISC_MSC_BIS_PLANS_V
ISC_MSC_BIS_QUARTERS_V
ISC_MSC_BIS_SUPPLIERS_V
ISC_MSC_BIS_YEARS_V
ISC_MSC_COST_BREAKDOWN_V
ISC_MSC_MFG_MEASURES_V
ISC_MSC_MFG_SERVICE_V
ISC_MSC_POST_COST_TREND_V
ISC_MSC_POST_COST_V
ISC_MSC_PURCHASING_BASE_V
ISC_MSC_PURCHASING_V
ISC_MSC_SERVICE_LEVELS_V
ISC_OPI_IND_CR_TAB_BASE_V
ISC_OPI_IND_CR_TAB_S
ISC_OPI_IND_QTD_S
ISC_OPI_IND_WK_S
ISC_OPI_TOP_ORD_QTD_BASE_V
ISC_OPI_TOP_ORD_QTD_S
ISC_OPI_TOP_ORD_WK_BASE_V
ISC_OPI_TOP_ORD_WK_S
ISC_ORG_CURRENCY_V
ISC_ORIG_DEST_FACILITY_V
ISC_PLAN_SNAPSHOT_V
ISC_QA_RESULTS_V
ISC_RISK_INDICATORS_S
ISC_RISK_SHIP_DLQT_S
ISC_SHIPMENT_DIRECTION_V
ISC_TOTAL_FREIG_CARR_V
ISC_TOTAL_ORIG_DEST_FAC_V
ISC_TOTAL_TRANSP_MODE_V
ISC_TRANSPORTATION_MODE_V
ISCBV_BACKLOGS_BASE_FCV
ISCBV_BACKLOGS_FCV
ISCBV_BOOK_SUM2_FCV
ISCBV_BOOKINGS_BASE_FCV
ISCBV_BOOKINGS_FCV
ISCBV_EDW_BACKLOG_SUM1_B_FCV
ISCBV_EDW_BACKLOG_SUM1_FCV
ISCBV_EDW_BOOK_SUM1_BASE_FCV
ISCBV_EDW_BOOK_SUM1_FCV

Tags: , No Comments »