Marketing Intelligence Concurrent Programs

Oracle Marketing Intelligence Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
BIMLILD BIM:Refresh of Lead Import Materialized Views
BIMRGLD BIM:Refresh of summary by Group Hierarchy
BIMLKPMV BIM:Initial build of Lead KPI Materialized Views
BIMLKPLD BIM:Refresh of the Lead KPI Materialized Views
BIMLQUMV BIM:Initial build of Lead Quality Materialized Views
BIMLQULD BIM:Refresh of Lead Quality Materialized Views
BIMLSOMV BIM:Initial build of Lead Sources Materialized Views
BIMLSOLD BIM:Refresh of Lead Sources Materialized Views
BIMRESMV BIM:Initial Build of the Interaction History Response Materialized Views
BIMRESLD BIM:Refresh of the Interaction History Response Materialized Views
BIM_SRCLIST_PROFIT_PKG BIM_SRCLIST_PROFIT_PKG
BIM_LEAD_CONV_SUMM_PKG BIM_LEAD_CONV_SUMM_PKG
BIM_EVENT_PERF_SUMM_PKG BIM_EVENT_PERF_SUMM_PKG
BIM_EVENT_RESP_SUMM_PKG BIM_EVENT_RESP_SUMM_PKG
BIM_EVNT_REVCST_SUMM_PKG BIM_EVNT_REVCST_SUMM_PKG
BIM_CUSTOMER_REV_PKG BIM_CUSTOMER_REV_PKG
BIM_CMPGN_RESP_SUMM_PKG BIM_CMPGN_RESP_SUMM_PKG
BIM_CAMPAIGNS_DENORM_PKG BIM_CAMPAIGNS_DENORM_PKG
BIM_CMPGN_RVCST_SUMM_PKG BIM_CMPGN_RVCST_SUMM_PKG
BIM_CMPGN_PERF_SUMM_PKG BIM_CMPGN_PERF_SUMM_PKG
BIM_DLY_RFSH_P1 Marketing Intelligence Daily Fact Table Refresh – Phase 1
BIM_EDW_INTR_RFS_PKG Load Interaction Fact, complete refresh of the Daily Summary Fact
BIM_SALES_CATEGORIES_PKG BIM_SALES_CATEGORIES_PKG
BIM_GEO_PKG BIM_GEO_PKG
BIM_TRGT_SGMT_DENORM_PKG BIM_TRGT_SGMT_DENORM_PKG
BIM_TRGT_SGMT_PERF_PKG BIM_TRGT_SGMT_PERF_PKG
BIM_SALES_CYCLE_SUMM_PKG BIM_SALES_CYCLE_SUMM_PKG
BIM_SRC_CODE_DETAILS_PKG BIM_SRC_CODE_DETAILS_PKG
BIM_OPPR_CYCLE_SUMM_PKG BIM_OPPR_CYCLE_SUMM_PKG
BIM_EDW_EVTFRCST_F_T Load Event Forecast Fact
BIM_EDW_CMPFRCST_F_T Load Campaign Forecast Fact
BIM_EDW_CMPFRCST_F Collect Campaign Forecast Fact
BIMRCVR Recover data for a given date
BIMRSPMV BIM:Initial build of Responses Materialized Views
BIMRSPLD BIM:Refresh of Responses Materialized Views
BIMLIMV BIM:Initial build of Lead Import Materialized Views
EDW_BIM_OPPTY_M_T Load Opportunity Dimension
EDW_BIM_CMPSTATS_M_T Load Campaign Status Dimension
EDW_BIM_TGSMT_M_T Load Target Segment Dimension
EDW_BIM_SRCLSTS_M_T Load Source List Dimension
EDW_BIM_OFFERS_M_T Load Marketing Offer Dimension
EDW_BIM_MKTSGMTS_M_T Load Market Segment Dimension
EDW_BIM_MDCHN_M_T Load Media Channel Dimension
EDW_BIM_OPP_STATUS_M_T Load Opportunity Status Dimension
EDW_BIM_LEAD_STATUS_M_T Load Lead Status Dimension
EDW_BIM_LEADS_M_T Load Leads Dimension
EDW_BIM_IH_RESLT_M_T Load Interaction Result Dimension
EDW_BIM_IH_REASN_M_T Load Interaction Reason Dimension
EDW_BIM_IH_OUTCM_M_T Load Interaction Outcome Dimension
EDW_BIM_IH_MEDIA_M_T Load Interaction Media Dimension
EDW_BIM_EVENTS_M_T Load Event Dimension
EDW_BIM_CMPGNS_M_T Load Campaign Dimension
BIM_EDW_INTR_DLY_SUMM Load Interaction Fact data into Daily Summay Fact
BIM_EDW_OPRNTIES_F Collect Opportunity Fact
BIM_EDW_LEADS_F Collect Leads Fact
BIM_EDW_INTRCTNS_F Collect Interaction Fact
BIM_EDW_EVTFRCST_F Collect Event Forecast Fact
EDW_BIM_TGSMT_M Collect Target Segment Dimension
EDW_BIM_SRCLSTS_M Collect Source List Dimension
EDW_BIM_OPP_STATUS_M Collect Opportunity Status Dimension
EDW_BIM_OPPORTUNITIES_M Collect Opportunity Dimension
EDW_BIM_OFFERS_M Collect Marketing Offer Dimension
EDW_BIM_MKTSGMTS_M Collect Market Segment Dimension
EDW_BIM_MDCHN_M Collect Media Channel Dimension
EDW_BIM_LEADS_M Collect Leads Dimension
EDW_BIM_LEAD_STATUS_M Collect Lead Status Dimension
EDW_BIM_IH_RESLT_M Collect Interaction Result Dimension
EDW_BIM_IH_REASN_M Collect Interaction Reason Dimension
EDW_BIM_IH_OUTCM_M Collect Interaction Outcome Dimension
EDW_BIM_IH_MEDIA_M Collect Interaction Media Dimension
EDW_BIM_EVENTS_M Collect Event Dimension
EDW_BIM_CMPSTATS_M Collect Campaign Status Dimension
EDW_BIM_CMPGNS_M Collect Campaign Dimension
EDW_BIM_SRCCODE_DTLS_PKG Collect Marketing Source Code details
EDW_BIM_TGSMT_DENORM Collect Datamart Target Segment Denormalised Table
EDW_BIM_CMPGNS_DENORM Collect Datamart Campaign Denormalised Table
BIM_EDW_OPRNTIES_F_T Load Opportunity Fact
EDW_BIM_LEADS_F_T Load Leads Fact
BIM_EDW_INTRCTNS_F_T Load Interaction Fact
BIMBUDMV BIM:Initial build of Budgets Materialized Views
BIMCMPLD BIM:Refresh of Campaigns Materialized Views
BIMCMPMV BIM:Initial build of Campaigns Materialized Views
BIMEVNLD BIM:Refresh of Events Materialized Views
BIMEVNMV BIM:Initial build of Events Materialized Views
BIMBUDLD BIM:Refresh of Budgets Materialized Views
BIMTRTAB BIM:Truncate all facts
BIMKPIFL BIM:Load Key Performance Indicator Facts
BIMKPILD BIM:Refresh of Key Performance Indicator Materialized Views
BIMKPIMV BIM:Initial build of Key Performance Indicator Materialized Views
BIMFFACT BIM:Load Marketing Facts for the first time
BIMRFACT BIM:Load Marketing Facts from previous refresh date
BIMACTLD BIM:Refresh Marketing Activities (Campaigns)
BIMLFACT Marketing Facts Load (Disabled)
BIM_LEAD_F_FACTS Update Leads First Time Base Summary
BIM_LEAD_I_FACTS Update Leads Incremental Base Summary
BIM_GH_SUM_REFRESH Update Leads by Current Sales Group Summary
BIM_GEN_SG_REFRESH Update Lead Metrics by Sales Group Summary
BIM_GEN_RS_REFRESH Update Lead Metrics by Resource Summary
BIM_AGING_REFRESH Update Lead Aging Summary
BIM_COST_REFRESH Update Lead Cost by Sales Group Summary
BIM_TRUNC_FACTS Truncate Marketing DBI Base Summary Tables
BIM_PRG_DEN_REFRESH Update Marketing Programs Denorm
BIM_MM_PRG_MV_REFRESH Update Marketing Activites By Country Summary
BIM_MM_CPL_MV_REFRESH Update Marketing Cost By Country Summary
BIM_MKT_F_FACTS Update Marketing First Time Base Summary
BIM_MKT_I_FACTS Update Marketing Incremental Base Summary
BIM_MKT_KPI_REFRESH Update Marketing Activities by Total Summary
BIMBUDLD1 BIM:Refresh of Budgets Materialized Views – 1
BIMCMPLD1 BIM:Refresh of Campaigns Materialized Views – 1
BIMACTLD_2B BIM:Refresh Marketing Activities (Activities)
BIMACTLD_BD BIM:Refresh Marketing Activities (BIM Dates)
BIMACTLD_3A BIM:Refresh Marketing Activities (Bin)
BIMACTLD_2C BIM:Refresh Marketing Activities (Indexes)
BIM_BGT_DEN_REFRESH Update Budget Denorm
BIM_BGT_F_FACTS Update Budget First Time Base Summary
BIM_BGT_I_FACTS Update Budget Incremental Base Summary
BIM_SOURCE_CODES_F Update of Source Codes – Initial Load
BIM_SOURCE_CODES_I Update of Source Codes – Incremental Load
BIM_PRG_DEN_I Update Marketing Source Denorm – Incremental Load
BIM_PRG_DEN_F Update Marketing Source Denorm – Initial Load
BIM_BGT_DEN_REFRESH_F Update Budget Denorm – Initial Load
BIM_BGT_DEN_REFRESH_I Update Budget Denorm – Incremental Load
BIM_SGMT_DENORM_F Update Marketing Segment Denorm – Initial Load
BIM_SGMT_ACT_I_FACTS Update Segment Activity Base Summary – Incremental Load
BIM_SEGMENT_DENORM Update Marketing Segment Denorm – Incremental Load
BIM_SGMT_F_FACTS Update Segment Base Summary – Initial Load
BIM_SGMT_I_FACTS Update Segment Base Summary – Incremental Load
BIM_SGMT_PARTY_F_FACTS Update Segment Party Base Summary – Initial Load
BIM_SGMT_PARTY_I_FACTS Update Segment Party Base Summary – Incremental Load
BIM_SGMT_ACT_F_FACTS Update Segment Activity Base Summary – Initial Load

Leave a reply

Your email address will not be published. Required fields are marked *