You are browsing the archive for Oracle Sales Intelligence.

Oracle Sales Intelligence Tables

Oracle Sales Intelligence module tables Information:

  • BIL_ACTIVITY_TOTAL
  • BIL_BI_CURRENCY_RATE
  • BIL_BI_DENLOG_STG
  • BIL_BI_ERROR_LOG
  • BIL_BI_FST_DTL_F
  • BIL_BI_FST_DTL_STG
  • BIL_BI_INDEX_MGMT
  • BIL_BI_NEW_FST_ID
  • BIL_BI_OPCNV_DENLOG_TMP
  • BIL_BI_OPCNV_F
  • BIL_BI_OPCNV_REVLOG
  • BIL_BI_OPCNV_STG
  • BIL_BI_OPDTL_DENLOG_TMP
  • BIL_BI_OPDTL_F
  • BIL_BI_OPDTL_REVLOG
  • BIL_BI_OPDTL_STG
  • BIL_BI_PIPEC_F
  • BIL_BI_PIPELINE_F
  • BIL_BI_PIPELINE_STG
  • BIL_BI_PROCESSED_FST_ID
  • BIL_BI_TIME
  • BIL_BI_WORKER_JOBS
  • BIL_CUST_TERR_INTF
  • BIL_DAILY_ACTIVITY
  • BIL_DO_L1_BASE_GRP_TEMP
  • BIL_DO_L1_LD_OPPTY_DLY
  • BIL_DO_L1_OPPTY_SUMRY
  • BIL_DO_L2_FCST_SUMRY
  • BIL_DO_L2_OPPTY_CAMP_SUMRY
  • BIL_DO_LD_OPPTY_DLY
  • BIL_DO_LD_OPPTY_PRD_DLY
  • BIL_DO_LD_OPPTY_PRD_SUM
  • BIL_DO_LD_OPPTY_SUM
  • BIL_IMP_CUST_SUMM
  • BIL_INV_TERR_INTF
  • BIL_OPTY_PERF_SUMM
  • BIL_ORD_TERR_INTF
  • BIL_PROD_SCT_WL_SUMM
  • BIL_QUOTE_TERR_INTF
  • BIL_REV_CUST_SUMM
  • BIL_ROC_SUMM
  • BIL_SI_OPTY_PROCUST_NP_PTN
  • BIL_SI_OPTY_PROCUST_PTN
  • BIL_SI_OPTY_TIME_NP_PTN
  • BIL_SI_OPTY_TIME_PTN
  • BIL_SI_PRD_PD_PTN
  • BIL_SLS_CHNL_PERF_SUMM
  • BIL_SREP_PERF_SUMM
  • BIL_TX_PROD_TMP

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