You are browsing the archive for BIL.

Views in Sales Intelligence Module

Views in Oracle Sales Intelligence Module

BIL_BI_PIPE_G_V
BIL_DIM_LVL_SLS_CHANNELS_V
BIL_DIMV_COMP_PLANS
BIL_DIMV_CREDIT_TYPE
BIL_DIMV_CURRENCIES
BIL_DIMV_CUSTOMERS
BIL_DIMV_EMP_STATUS
BIL_DIMV_INTEREST_CODES
BIL_DIMV_INTEREST_TYPES
BIL_DIMV_JOB_TITLE
BIL_DIMV_OPTY
BIL_DIMV_OPTY_STATUSES
BIL_DIMV_PLAN_ELEMENTS
BIL_DIMV_PRIM_INT_CODES
BIL_DIMV_PROD_LOV
BIL_DIMV_QUALIFICATIONS
BIL_DIMV_RATING_FACTORS
BIL_DIMV_SALES_GROUPS
BIL_DIMV_SALES_STAGES
BIL_DIMV_SALESFORCE
BIL_DIMV_SEC_INT_CODES
BIL_DIMV_SKILLS
BIL_DIMV_SLS_CHANNELS
BIL_DIMV_SLSPROD_HIER
BIL_DIMV_SRV_SVTYS
BIL_DIMV_TERR_HIER
BIL_DIMV_TERRITORIES
BIL_DIMV_TOP_BOTTOM
BIL_DIMV_TOT_COMP_PLANS
BIL_DIMV_TOT_JOB_TITLES
BIL_DIMV_TOT_SLSFORCE
BIL_DIMV_TOT_SLSPRODS
BIL_DIMV_TOT_TERRITORY
BIL_DIMV_UOM
BIL_OBI_FST_PG_V
BIL_OBI_OPDTL_V
BIL_OBI_OPTY_PIPE_PG_V
BIL_OBI_RS_GROUP0_DENORM_V
BIL_OBI_RS_GROUP1_DENORM_V
BIL_OBI_RS_GROUP2_DENORM_V
BIL_OBI_RS_GROUP3_DENORM_V
BIL_OBI_RS_GROUP4_DENORM_V
BIL_OBI_RS_GROUPB_DENORM_V
BIL_OBI_RS_GROUPS_V
BIL_TX_COMPETITOR_V
BIL_TX_CURRENCY_CODES_V
BIL_TX_CUSTOMER_V
BIL_TX_FCST_TYP_V
BIL_TX_FW_ST_V
BIL_TX_OPP_CLOSE_REASON_V
BIL_TX_OPP_SOURCE_V
BIL_TX_OPTY_STATUS_V
BIL_TX_PARTNER_V
BIL_TX_PERIOD_NAME_V
BIL_TX_PERIOD_TYPE_ALL_V
BIL_TX_PERIOD_TYPE_V
BIL_TX_PRODUCT_V
BIL_TX_SALES_CHANNEL_V
BIL_TX_SALES_GROUP_HG_V
BIL_TX_SALES_GROUP_V
BIL_TX_SALES_METHODOLOGY_V
BIL_TX_SALES_PERSON_V
BIL_TX_SALES_STAGE_V
BIL_TX_WIN_PROBABILITY_V

Sales Intelligence Profile Options

Oracle Sales Intelligence Profile Options



PROFILE OPTION SHORT CODE PROFILE OPTION NAME
BIL_ROOT_SALES_GROUP BIL: Root Sales Group
BIL_SI_REPORT_RANGE BIL: SI Report Range
BIL_BI_BASE_FST_PERIOD_TYPE BIL: Base Forecast Period Type
BIL_BI_MAP_ENT_FST_PERIOD_TYPE BIL: Mapping Enterprise Forecast Period Type
BIL_BI_ASN_IMPLEMENTED BIL: Oracle Sales Implementation Date (mm/dd/yyyy)
BIL_BI_FST_ROLLUP BIL: Enable Forecast Period Rollup
BIL_DO_L1_GRP_AGGR_LVL BIL: Sales Group Aggregation Level
BIL_DISPLAY_NODATA_FLAG BIL : Display message- No Data to Report

Sales Intelligence Concurrent Programs

Oracle Sales Intelligence Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
BIL_OBI_GROUPS_DENORM Update Sales Group Hierarchy (OBIEE)
BIL_BI_PIPELINE_F_INCR Update Sales Pipeline Base Summary
BIL_BI_OPCNV_F_INIT Load Sales Opportunity Conversion Base Summary
BIL_BI_OPTY_DTL_F_INIT Load Sales Opportunity Base Summary
BIL_BI_FST_SUMINIT Load Sales Forecast Base Summary
BIL_BI_OPTY_DTL_F_SW Sales Opportunity Base Summary Subworker
BIL_BI_FST_SUMWRK Sales Forecast Base Summary Subworker
BIL_BI_OPCNV_SUMM_SW Sales Opportunity Conversion Base Summary Subworker
BIL_BI_OPCNV_F_INCR Update Sales Opportunity Conversion Base Summary
BIL_BI_OPTY_DTL_F_INCR Update Sales Opportunity Base Summary
BIL_BI_FST_SUMINCR Update Sales Forecast Base Summary
BIL_BI_G_MV_REFRESH Update Sales Forecast Summary
BIL_BI_M_MV_REFRESH Update Salesperson and Sales Group View using Current Hierarchy
BIL_BI_OPTY_DTL_MV_REFRESH Update Sales Opportunity by Period Summary
BIL_BI_OPTY_CONV_MV_REFRESH Update Sales Opportunity Conversion by Period Summary
BIL_BI_OPTY_TIME_MV_REFRESH Update Sales Opportunity and Conversion by Period Summary
BIL_BI_OPFST_MV_REFRESH Update Sales Opportunity and Forecast by Sales Group Summary
BIL_BI_CNQTE_MV_REFRESH Update Quote, Quota and Commission by Sales Group Summary
BIL_BI_PIPELINE_F Load Sales Pipeline Base Summary
BIL_BI_PURGE_OBJ Delete Partial Data From Sales DBI Object
BIL_BI_TRUNC_OBJ Delete Complete Data in Sales DBI Object