You are browsing the archive for BIS.

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

Oracle Applications BIS Tables

Oracle Applications BIS module key tables:

  • BIS – Applications BIS
  • BIS_ACTUAL_VALUES
  • BIS_AK_CUSTOM_REGIONS
  • BIS_AK_CUSTOM_REGION_ITEMS
  • BIS_AK_REGION_EXTENSION
  • BIS_AK_REGION_ITEM_EXTENSION
  • BIS_APPLICATION_MEASURES
  • BIS_BUCKET
  • BIS_BUCKET_CUSTOMIZATIONS
  • BIS_BUCKET_CUSTOMIZATIONS_TL
  • BIS_BUCKET_TL
  • BIS_BUSINESS_PLANS
  • BIS_BUSINESS_PLANS_TL
  • BIS_COLOR_TRIGGERS_B
  • BIS_COLOR_TRIGGERS_SET_TL
  • BIS_CUSTOM_CAUSE_EFFECT_RELS
  • BIS_CUSTOM_RELATED_LINKS
  • BIS_CUSTOM_RELATED_LINKS_TL
  • BIS_DIMENSIONS
  • BIS_DIMENSIONS_TL
  • BIS_FLEX_SEG_MAPPING_LINES
  • BIS_FN_SAVE_FIELDS
  • BIS_FORM_FUNCTION_EXTENSION
  • BIS_FORM_FUNCTION_EXTENSION_TL
  • BIS_FUNCTIONAL_AREAS
  • BIS_FUNCTIONAL_AREAS_TL
  • BIS_FUNC_AREA_APP_DEPENDENCY
  • BIS_HTML_CLOB
  • BIS_INDICATORS
  • BIS_INDICATORS_TL
  • BIS_INDICATOR_DIMENSIONS
  • BIS_INDICATOR_RESPS
  • BIS_IND_CUSTOMIZATIONS
  • BIS_LEVELS
  • BIS_LEVELS_CUSTOMIZATIONS
  • BIS_LEVELS_CUSTOMIZATIONS_TL
  • BIS_LEVELS_TL
  • BIS_MEASURES_EXTENSION
  • BIS_MEASURES_EXTENSION_TL
  • BIS_MODULES_STATUS
  • BIS_OBJECTS
  • BIS_OBJ_DEPENDENCY
  • BIS_OBJ_INDEXES
  • BIS_OBJ_PROG_LINKAGES
  • BIS_OBJ_PROPERTIES
  • BIS_OBJ_REFRESH_HISTORY
  • BIS_PARAM_COLOR_TRIGGERS
  • BIS_PARAM_DIMENSION_MAP
  • BIS_PMF_ALERT_PARAMETERS
  • BIS_PMF_POPULATE_PORTLET
  • BIS_REFRESH_LOG
  • BIS_RELATED_LINKS
  • BIS_RELATED_LINKS_TL
  • BIS_REQUEST_SET_OBJECTS
  • BIS_REQUEST_SET_OPTIONS
  • BIS_RSS_PORTLETS
  • BIS_RSS_PORTLETS_TL
  • BIS_RS_PROG_RUN_HISTORY
  • BIS_RS_RUN_HISTORY
  • BIS_RS_STAGE_RUN_HISTORY
  • BIS_SCHEDULER
  • BIS_SCHEDULE_PREFERENCES
  • BIS_SEARCH_RESULTS
  • BIS_SYSTEM_DATE
  • BIS_SYSTEM_TEST_ACTUALS
  • BIS_TARGET_LEVELS
  • BIS_TARGET_LEVELS_TL
  • BIS_TARGET_VALUES
  • BIS_TERRITORY_HIERARCHIES
  • BIS_TREND_FUNCTIONS
  • BIS_USER_ATTRIBUTES
  • BIS_USER_EXCLUDED_LINKS
  • BIS_USER_IND_SELECTIONS
  • BIS_USER_REPORT_OPTIONS
  • BIS_USER_TREND_PLUGS
  • BIS_WEIGHTED_MEASURE_DEFNS
  • BIS_WEIGHTED_MEASURE_DEPENDS
  • BIS_WEIGHTED_MEASURE_PARAMS
  • BIS_WEIGHTED_MEASURE_SCORES
  • BIS_WEIGHTED_MEASURE_WEIGHTS
  • EDWCMPALLCLASSES
  • EDW_ALL_COLUMNS_MD
  • EDW_ALL_CONC_PROGRAMS
  • EDW_ATTRIBUTE_MAPPINGS
  • EDW_ATTRIBUTE_PROPERTIES
  • EDW_ATTRIBUTE_SETS_MD
  • EDW_ATTRIBUTE_SET_COLUMN_MD
  • EDW_AUTO_COL_LOAD_DETAIL
  • EDW_AUTO_FACT_DIMS
  • EDW_BIM_SCHN_SLSCHN_LSTG
  • EDW_BIM_SCHN_SLSCHN_LTC
  • EDW_BIM_SLSCHNLS_M
  • EDW_CALSUM4_BSC
  • EDW_CALSUM4_BSC_LOG
  • EDW_CDI_DIM_MISSING_KEYS
  • EDW_CDI_KEY_VALUES
  • EDW_CDI_RESULTS
  • EDW_CFIG_OPTIONS
  • EDW_COLLECTION_DETAIL_LOG
  • EDW_COLL_ERROR_LOG
  • EDW_COLL_PROGRESS_LOG
  • EDW_CONC_PROGRAM_LOG
  • EDW_CONFIG_OBJECTS
  • EDW_CONS_SET_OF_BOOKS
  • EDW_DCDM_DEMAND_CLS_LSTG
  • EDW_DCDM_DEMAND_CLS_LTC
  • EDW_DEMAND_CLASS_M
  • EDW_DIMENSIONS_MD
  • EDW_DIM_ATTRIBUTES_MD
  • EDW_EQUI_SET_OF_BOOKS
  • EDW_ERROR_LOG
  • EDW_FACTS_MD
  • EDW_FACT_ATTRIBUTES_MD
  • EDW_FACT_DIM_RELATIONS_MD
  • EDW_FACT_FLEX_FK_MAPS
  • EDW_FACT_HIER_MD
  • EDW_FLEX_ATTRIBUTE_MAPPINGS
  • EDW_FLEX_CONTROLS
  • EDW_FLEX_DIM10_L1_LSTG
  • EDW_FLEX_DIM10_L1_LTC
  • EDW_FLEX_DIM10_L2_LSTG
  • EDW_FLEX_DIM10_L2_LTC
  • EDW_FLEX_DIM10_M
  • EDW_FLEX_DIM11_L1_LSTG
  • EDW_FLEX_DIM11_L1_LTC
  • EDW_FLEX_DIM11_L2_LSTG
  • EDW_FLEX_DIM11_L2_LTC
  • EDW_FLEX_DIM11_M
  • EDW_FLEX_DIM12_L1_LSTG
  • EDW_FLEX_DIM12_L1_LTC
  • EDW_FLEX_DIM12_L2_LSTG
  • EDW_FLEX_DIM12_L2_LTC
  • EDW_FLEX_DIM12_M
  • EDW_FLEX_DIM13_L1_LSTG
  • EDW_FLEX_DIM13_L1_LTC
  • EDW_FLEX_DIM13_L2_LSTG
  • EDW_FLEX_DIM13_L2_LTC
  • EDW_FLEX_DIM13_M
  • EDW_FLEX_DIM14_L1_LSTG
  • EDW_FLEX_DIM14_L1_LTC
  • EDW_FLEX_DIM14_L2_LSTG
  • EDW_FLEX_DIM14_L2_LTC
  • EDW_FLEX_DIM14_M
  • EDW_FLEX_DIM15_L1_LSTG
  • EDW_FLEX_DIM15_L1_LTC
  • EDW_FLEX_DIM15_L2_LSTG
  • EDW_FLEX_DIM15_L2_LTC
  • EDW_FLEX_DIM15_M
  • EDW_FLEX_DIM16_L1_LSTG
  • EDW_FLEX_DIM16_L1_LTC
  • EDW_FLEX_DIM16_L2_LSTG
  • EDW_FLEX_DIM16_L2_LTC
  • EDW_FLEX_DIM16_M
  • EDW_FLEX_DIM17_L1_LSTG
  • EDW_FLEX_DIM17_L1_LTC
  • EDW_FLEX_DIM17_L2_LSTG
  • EDW_FLEX_DIM17_L2_LTC
  • EDW_FLEX_DIM17_M
  • EDW_FLEX_DIM18_L1_LSTG
  • EDW_FLEX_DIM18_L1_LTC
  • EDW_FLEX_DIM18_L2_LSTG
  • EDW_FLEX_DIM18_L2_LTC
  • EDW_FLEX_DIM18_M
  • EDW_FLEX_DIM19_L1_LSTG
  • EDW_FLEX_DIM19_L1_LTC
  • EDW_FLEX_DIM19_L2_LSTG
  • EDW_FLEX_DIM19_L2_LTC
  • EDW_FLEX_DIM19_M
  • EDW_FLEX_DIM1_L1_LSTG
  • EDW_FLEX_DIM1_L1_LTC
  • EDW_FLEX_DIM1_L2_LSTG
  • EDW_FLEX_DIM1_L2_LTC
  • EDW_FLEX_DIM1_M
  • EDW_FLEX_DIM20_L1_LSTG
  • EDW_FLEX_DIM20_L1_LTC
  • EDW_FLEX_DIM20_L2_LSTG
  • EDW_FLEX_DIM20_L2_LTC
  • EDW_FLEX_DIM20_M
  • EDW_FLEX_DIM21_L1_LSTG
  • EDW_FLEX_DIM21_L1_LTC
  • EDW_FLEX_DIM21_L2_LSTG
  • EDW_FLEX_DIM21_L2_LTC
  • EDW_FLEX_DIM21_M
  • EDW_FLEX_DIM22_L1_LSTG
  • EDW_FLEX_DIM22_L1_LTC
  • EDW_FLEX_DIM22_L2_LTC
  • EDW_FLEX_DIM22_M
  • EDW_FLEX_DIM23_L1_LSTG
  • EDW_FLEX_DIM23_L1_LTC
  • EDW_FLEX_DIM23_L2_LSTG
  • EDW_FLEX_DIM23_L2_LTC
  • EDW_FLEX_DIM23_M
  • EDW_FLEX_DIM24_L1_LSTG
  • EDW_FLEX_DIM24_L1_LTC
  • EDW_FLEX_DIM24_L2_LSTG
  • EDW_FLEX_DIM24_L2_LTC
  • EDW_FLEX_DIM24_M
  • EDW_FLEX_DIM25_L1_LSTG
  • EDW_FLEX_DIM25_L1_LTC
  • EDW_FLEX_DIM25_L2_LSTG
  • EDW_FLEX_DIM25_L2_LTC
  • EDW_FLEX_DIM25_M
  • EDW_FLEX_DIM26_L1_LSTG
  • EDW_FLEX_DIM26_L1_LTC
  • EDW_FLEX_DIM26_L2_LSTG
  • EDW_FLEX_DIM26_L2_LTC
  • EDW_FLEX_DIM26_M
  • EDW_FLEX_DIM27_L1_LSTG
  • EDW_FLEX_DIM27_L1_LTC
  • EDW_FLEX_DIM27_L2_LSTG
  • EDW_FLEX_DIM27_L2_LTC
  • EDW_FLEX_DIM27_M
  • EDW_FLEX_DIM28_L1_LSTG
  • EDW_FLEX_DIM28_L1_LTC
  • EDW_FLEX_DIM28_L2_LSTG
  • EDW_FLEX_DIM28_L2_LTC
  • EDW_FLEX_DIM28_M
  • EDW_FLEX_DIM29_L1_LSTG
  • EDW_FLEX_DIM29_L1_LTC
  • EDW_FLEX_DIM29_L2_LSTG
  • EDW_FLEX_DIM29_L2_LTC
  • EDW_FLEX_DIM29_M
  • EDW_FLEX_DIM2_L1_LSTG
  • EDW_FLEX_DIM2_L1_LTC
  • EDW_FLEX_DIM2_L2_LSTG
  • EDW_FLEX_DIM2_L2_LTC
  • EDW_FLEX_DIM2_M
  • EDW_FLEX_DIM30_L1_LSTG
  • EDW_FLEX_DIM30_L1_LTC
  • EDW_FLEX_DIM30_L2_LSTG
  • EDW_FLEX_DIM30_L2_LTC
  • EDW_FLEX_DIM30_M
  • EDW_FLEX_DIM31_L1_LSTG
  • EDW_FLEX_DIM31_L1_LTC
  • EDW_FLEX_DIM31_L2_LSTG
  • EDW_FLEX_DIM31_L2_LTC
  • EDW_FLEX_DIM31_M
  • EDW_FLEX_DIM32_L1_LSTG
  • EDW_FLEX_DIM32_L1_LTC
  • EDW_FLEX_DIM32_L2_LSTG
  • EDW_FLEX_DIM32_L2_LTC
  • EDW_FLEX_DIM32_M
  • EDW_FLEX_DIM33_L1_LSTG
  • EDW_FLEX_DIM33_L1_LTC
  • EDW_FLEX_DIM33_L2_LSTG
  • EDW_FLEX_DIM33_L2_LTC
  • EDW_FLEX_DIM33_M
  • EDW_FLEX_DIM34_L1_LSTG
  • EDW_FLEX_DIM34_L1_LTC
  • EDW_FLEX_DIM34_L2_LSTG
  • EDW_FLEX_DIM34_L2_LTC
  • EDW_FLEX_DIM34_M
  • EDW_FLEX_DIM35_L1_LSTG
  • EDW_FLEX_DIM35_L1_LTC
  • EDW_FLEX_DIM35_L2_LSTG
  • EDW_FLEX_DIM35_L2_LTC
  • EDW_FLEX_DIM35_M
  • EDW_FLEX_DIM36_L1_LSTG
  • EDW_FLEX_DIM36_L1_LTC
  • EDW_FLEX_DIM36_L2_LSTG
  • EDW_FLEX_DIM36_L2_LTC
  • EDW_FLEX_DIM36_M
  • EDW_FLEX_DIM37_L1_LSTG
  • EDW_FLEX_DIM37_L1_LTC
  • EDW_FLEX_DIM37_L2_LSTG
  • EDW_FLEX_DIM37_L2_LTC
  • EDW_FLEX_DIM37_M
  • EDW_FLEX_DIM38_L1_LSTG
  • EDW_FLEX_DIM38_L1_LTC
  • EDW_FLEX_DIM38_L2_LSTG
  • EDW_FLEX_DIM38_L2_LTC
  • EDW_FLEX_DIM38_M
  • EDW_FLEX_DIM39_L1_LSTG
  • EDW_FLEX_DIM39_L1_LTC
  • EDW_FLEX_DIM39_L2_LSTG
  • EDW_FLEX_DIM39_L2_LTC
  • EDW_FLEX_DIM39_M
  • EDW_FLEX_DIM3_L1_LSTG
  • EDW_FLEX_DIM3_L1_LTC
  • EDW_FLEX_DIM3_L2_LSTG
  • EDW_FLEX_DIM3_L2_LTC
  • EDW_FLEX_DIM3_M
  • EDW_FLEX_DIM40_L1_LSTG
  • EDW_FLEX_DIM40_L1_LTC
  • EDW_FLEX_DIM40_L2_LSTG
  • EDW_FLEX_DIM40_L2_LTC
  • EDW_FLEX_DIM40_M
  • EDW_FLEX_DIM41_L1_LSTG
  • EDW_FLEX_DIM41_L1_LTC
  • EDW_FLEX_DIM41_L2_LSTG
  • EDW_FLEX_DIM41_L2_LTC
  • EDW_FLEX_DIM41_M
  • EDW_FLEX_DIM42_L1_LSTG
  • EDW_FLEX_DIM42_L1_LTC
  • EDW_FLEX_DIM42_L2_LSTG
  • EDW_FLEX_DIM42_L2_LTC
  • EDW_FLEX_DIM42_M
  • EDW_FLEX_DIM43_L1_LSTG
  • EDW_FLEX_DIM43_L1_LTC
  • EDW_FLEX_DIM43_L2_LSTG
  • EDW_FLEX_DIM43_L2_LTC
  • EDW_FLEX_DIM43_M
  • EDW_FLEX_DIM44_L1_LSTG
  • EDW_FLEX_DIM44_L1_LTC
  • EDW_FLEX_DIM44_L2_LSTG
  • EDW_FLEX_DIM44_L2_LTC
  • EDW_FLEX_DIM44_M
  • EDW_FLEX_DIM45_L1_LSTG
  • EDW_FLEX_DIM45_L1_LTC
  • EDW_FLEX_DIM45_L2_LSTG
  • EDW_FLEX_DIM45_L2_LTC
  • EDW_FLEX_DIM45_M
  • EDW_FLEX_DIM46_L1_LSTG
  • EDW_FLEX_DIM46_L1_LTC
  • EDW_FLEX_DIM46_L2_LSTG
  • EDW_FLEX_DIM46_L2_LTC
  • EDW_FLEX_DIM46_M
  • EDW_FLEX_DIM47_L1_LSTG
  • EDW_FLEX_DIM47_L1_LTC
  • EDW_FLEX_DIM47_L2_LSTG
  • EDW_FLEX_DIM47_L2_LTC
  • EDW_FLEX_DIM47_M
  • EDW_FLEX_DIM48_L1_LSTG
  • EDW_FLEX_DIM48_L1_LTC
  • EDW_FLEX_DIM48_L2_LSTG
  • EDW_FLEX_DIM48_L2_LTC
  • EDW_FLEX_DIM48_M
  • EDW_FLEX_DIM49_L1_LSTG
  • EDW_FLEX_DIM49_L1_LTC
  • EDW_FLEX_DIM49_L2_LSTG
  • EDW_FLEX_DIM49_L2_LTC
  • EDW_FLEX_DIM49_M
  • EDW_FLEX_DIM4_L1_LSTG
  • EDW_FLEX_DIM4_L1_LTC
  • EDW_FLEX_DIM4_L2_LSTG
  • EDW_FLEX_DIM4_L2_LTC
  • EDW_FLEX_DIM4_M
  • EDW_FLEX_DIM50_L1_LSTG
  • EDW_FLEX_DIM50_L1_LTC
  • EDW_FLEX_DIM50_L2_LSTG
  • EDW_FLEX_DIM50_L2_LTC
  • EDW_FLEX_DIM50_M
  • EDW_FLEX_DIM5_L1_LSTG
  • EDW_FLEX_DIM5_L1_LTC
  • EDW_FLEX_DIM5_L2_LSTG
  • EDW_FLEX_DIM5_L2_LTC
  • EDW_FLEX_DIM5_M
  • EDW_FLEX_DIM6_L1_LSTG
  • EDW_FLEX_DIM6_L1_LTC
  • EDW_FLEX_DIM6_L2_LSTG
  • EDW_FLEX_DIM6_L2_LTC
  • EDW_FLEX_DIM6_M
  • EDW_FLEX_DIM7_L1_LSTG
  • EDW_FLEX_DIM7_L1_LTC
  • EDW_FLEX_DIM7_L2_LSTG
  • EDW_FLEX_DIM7_L2_LTC
  • EDW_FLEX_DIM7_M
  • EDW_FLEX_DIM8_L1_LSTG
  • EDW_FLEX_DIM8_L1_LTC
  • EDW_FLEX_DIM8_L2_LSTG
  • EDW_FLEX_DIM8_L2_LTC
  • EDW_FLEX_DIM8_M
  • EDW_FLEX_DIM9_L1_LSTG
  • EDW_FLEX_DIM9_L1_LTC
  • EDW_FLEX_DIM9_L2_LSTG
  • EDW_FLEX_DIM9_L2_LTC
  • EDW_FLEX_DIM9_M
  • EDW_FLEX_DIMENSION_MAPPINGS
  • EDW_FLEX_SEG_MAPPINGS
  • EDW_FOREIGN_KEYS_MD
  • EDW_FOREIGN_KEY_COLUMNS_MD
  • EDW_GENERAL_LOG
  • EDW_GEOGRAPHY_A_LTC
  • EDW_GEOGRAPHY_M
  • EDW_GEOG_AREA1_LSTG
  • EDW_GEOG_AREA1_LTC
  • EDW_GEOG_AREA2_LSTG
  • EDW_GEOG_AREA2_LTC
  • EDW_GEOG_CITY_LSTG
  • EDW_GEOG_CITY_LTC
  • EDW_GEOG_COUNTRY_LSTG
  • EDW_GEOG_COUNTRY_LTC
  • EDW_GEOG_LOCATION_LSTG
  • EDW_GEOG_LOCATION_LTC
  • EDW_GEOG_POSTCODE_CITY_LSTG
  • EDW_GEOG_POSTCODE_CITY_LTC
  • EDW_GEOG_POSTCODE_LSTG
  • EDW_GEOG_POSTCODE_LTC
  • EDW_GEOG_REGION_LSTG
  • EDW_GEOG_REGION_LTC
  • EDW_GEOG_STATE_LSTG
  • EDW_GEOG_STATE_LTC
  • EDW_GEOG_STATE_REGION_LSTG
  • EDW_GEOG_STATE_REGION_LTC
  • EDW_GL_ACCT10_M
  • EDW_GL_ACCT10_M_TEMP
  • EDW_GL_ACCT1_M
  • EDW_GL_ACCT1_M_TEMP
  • EDW_GL_ACCT2_M
  • EDW_GL_ACCT2_M_TEMP
  • EDW_GL_ACCT3_M
  • EDW_GL_ACCT3_M_TEMP
  • EDW_GL_ACCT4_M
  • EDW_GL_ACCT4_M_TEMP
  • EDW_GL_ACCT5_M
  • EDW_GL_ACCT5_M_TEMP
  • EDW_GL_ACCT6_M
  • EDW_GL_ACCT6_M_TEMP
  • EDW_GL_ACCT7_M
  • EDW_GL_ACCT7_M_TEMP
  • EDW_GL_ACCT8_M
  • EDW_GL_ACCT8_M_TEMP
  • EDW_GL_ACCT9_M
  • EDW_GL_ACCT9_M_TEMP
  • EDW_HIERARCHIES_MD
  • EDW_HIERARCHY_LEVEL_MD
  • EDW_HR_PERM_ASSIGN_LSTG
  • EDW_HR_PERM_ASSIGN_LTC
  • EDW_HR_PERM_PERSON_LSTG
  • EDW_HR_PERM_PERSON_LTC
  • EDW_HR_PERSON_A_LTC
  • EDW_HR_PERSON_M
  • EDW_INSTANCE_A_LTC
  • EDW_INSTANCE_LOG
  • EDW_INSTANCE_LSTG
  • EDW_INSTANCE_LTC
  • EDW_INSTANCE_M
  • EDW_LEVELS_MD
  • EDW_LEVEL_ATTS_MD
  • EDW_LEVEL_RELATIONS_MD
  • EDW_LEVEL_TABLE_ATTS_MD
  • EDW_LKUP_LOOKUP_CODE_LSTG
  • EDW_LKUP_LOOKUP_CODE_LTC
  • EDW_LOAD_PROGRESS_LOG
  • EDW_LOCAL_CONS_SET_OF_BOOKS
  • EDW_LOCAL_EQUI_SET_OF_BOOKS
  • EDW_LOCAL_FACT_FLEX_FK_MAPS
  • EDW_LOCAL_FLEX_SEG_MAPPINGS
  • EDW_LOCAL_GENERATION_STATUS
  • EDW_LOCAL_INSTANCE
  • EDW_LOCAL_INSTANCE_TL
  • EDW_LOCAL_SET_OF_BOOKS
  • EDW_LOCAL_SYSTEM_PARAMETERS
  • EDW_LOOKUP_A_LTC
  • EDW_LOOKUP_M
  • EDW_MRP_FCDM_FORECAST_LSTG
  • EDW_MRP_FCDM_FORECAST_LTC
  • EDW_MRP_FCDM_FORECAST_SET_LSTG
  • EDW_MRP_FCDM_FORECAST_SET_LTC
  • EDW_MRP_FORECAST_M
  • EDW_MRP_PLAN_NAME_M
  • EDW_MRP_PNDM_PLAN_NAME_LSTG
  • EDW_MRP_PNDM_PLAN_NAME_LTC
  • EDW_MTL_ILDM_LOCATOR_LSTG
  • EDW_MTL_ILDM_LOCATOR_LTC
  • EDW_MTL_ILDM_PLANT_LSTG
  • EDW_MTL_ILDM_PLANT_LTC
  • EDW_MTL_ILDM_SUB_INV_LSTG
  • EDW_MTL_ILDM_SUB_INV_LTC
  • EDW_MTL_INVENTORY_LOC_M
  • EDW_MTL_UNITOFMSR_M
  • EDW_NA
  • EDW_OBJECT_DEPLOYMENTS
  • EDW_OPTION_DETAILS
  • EDW_ORGANIZATION_A_LTC
  • EDW_ORGANIZATION_M
  • EDW_ORGA_BUSINESS_GRP_LSTG
  • EDW_ORGA_BUSINESS_GRP_LTC
  • EDW_ORGA_LEG_ENTITY_LSTG
  • EDW_ORGA_LEG_ENTITY_LTC
  • EDW_ORGA_OPER_UNIT_LSTG
  • EDW_ORGA_OPER_UNIT_LTC
  • EDW_ORGA_ORG_LSTG
  • EDW_ORGA_ORG_LTC
  • EDW_PUBLISH_LOG
  • EDW_PUSH_DETAIL_LOG
  • EDW_PVT_COLUMNS_MD
  • EDW_PVT_KEY_COLUMNS_MD
  • EDW_PVT_LEVEL_RELATION_MD
  • EDW_PVT_MAPPINGS_MD
  • EDW_PVT_MAP_COLUMNS_MD
  • EDW_PVT_MAP_COLUMNS_SRC_MD
  • EDW_PVT_MAP_COLUMNS_TGT_MD
  • EDW_PVT_MAP_FUNC_MD
  • EDW_PVT_MAP_KEY_USAGES_MD
  • EDW_PVT_MAP_PROPERTIES_MD
  • EDW_PVT_MAP_SOURCES_MD
  • EDW_PVT_MAP_TARGETS_MD
  • EDW_PVT_SEQUENCES_MD
  • EDW_PVT_VIEWS_MD
  • EDW_RELATIONMAPPING_MD
  • EDW_RELATIONS_MD
  • EDW_SEC_DIM_ACCESS
  • EDW_SEC_DIM_INFO_T
  • EDW_SEC_FACT_INFO_T
  • EDW_SEC_ITEMSET_INFO_T
  • EDW_SEC_LVL_INFO_T
  • EDW_SEC_REF_INFO_T
  • EDW_SEGMENT_CLASSES
  • EDW_SET_OF_BOOKS
  • EDW_SIZE_INPUT
  • EDW_SIZE_OUTPUT
  • EDW_SOURCE_INSTANCES
  • EDW_SOURCE_INSTANCES_TL
  • EDW_SOURCE_VIEWS
  • EDW_SR_CFIG_PARAMETERS
  • EDW_SV_FLEX_ASSIGNMENTS
  • EDW_SYSTEM_PARAMETERS
  • EDW_TABLES_MD
  • EDW_TEMP_COLLECTION_LOG
  • EDW_TPRT_P1_TPARTNER_LSTG
  • EDW_TPRT_P1_TPARTNER_LTC
  • EDW_TPRT_P2_TPARTNER_LSTG
  • EDW_TPRT_P2_TPARTNER_LTC
  • EDW_TPRT_P3_TPARTNER_LSTG
  • EDW_TPRT_P3_TPARTNER_LTC
  • EDW_TPRT_P4_TPARTNER_LSTG
  • EDW_TPRT_P4_TPARTNER_LTC
  • EDW_TPRT_TPARTNER_LOC_LSTG
  • EDW_TPRT_TPARTNER_LOC_LTC
  • EDW_TPRT_TRADE_PARTNER_LSTG
  • EDW_TPRT_TRADE_PARTNER_LTC
  • EDW_TPRT_TRD_PARTNER_A_LTC
  • EDW_TRD_PARTNER_M
  • EDW_UNIQUE_KEYS_MD
  • EDW_UNIQUE_KEY_COLUMNS_MD
  • EDW_VBH_ROOTS
  • EDW_VBH_TEMP1
  • EDW_VBH_TEMP10
  • EDW_VBH_TEMP2
  • EDW_VBH_TEMP3
  • EDW_VBH_TEMP4
  • EDW_VBH_TEMP5
  • EDW_VBH_TEMP6
  • EDW_VBH_TEMP7
  • EDW_VBH_TEMP8
  • EDW_VBH_TEMP9
  • EDW_WH_CFIG_PARAMETERS

Applications BIS Profile Options

Oracle Applications BIS Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
BIS_PRIMARY_CURDISP_NAME BIS: Primary Currency Display Name
BIS_SECONDARY_CURDISP_NAME BIS: Secondary Currency Display Name
EDW_LOGFILE_DIR EDW: Log file directory
BIS_PMF_DEBUG BIS: Debug Mode
BIS_SOURCE BIS: Source
EDW_UPDATE_TYPE EDW : Loader Engine Update Type
EDW_LOAD_ROLLBACK EDW : Rollback Segment
EDW_FK_SET_SIZE EDW : Foreign Key Set Size
EDW_SMART_UPDATE EDW : Smart Update
EDW_FK_USE_NL EDW : Use NL in FK Lookup
EDW_LTC_COPY_MERGE_NL EDW : Use NL in level copy table merge
EDW_USE_EXP_PLAN EDW : Use Explain Plan
EDW_COLLECTION_SIZE EDW : Loader Engine Commit Size
EDW_PARALLEL EDW : Degree of Parallelism
EDW_TEST_MODE EDW : Test Mode
EDW_HASH_AREA_SIZE EDW : Hash Area Size (Bytes)
EDW_SORT_AREA_SIZE EDW : Sort Area Size (Bytes)
EDW_FRESH_RESTART EDW : Fresh Restart
EDW_OP_TABLE_SPACE EDW : Operation Tablespace
EDW_APPS_TO_APPS EDW: Loop Back Database Link
EDW_APPS_TO_WH EDW: Runtime Database Link
EDW_COL_OP_TABLE_SPACE EDW : Collection Operation Tablespace
EDW_PARALLEL_SRC EDW : Degree of Parallelism on the source
BIS_IMPLEMENTATION_TYPE BIS: Implementation Type
BIS_PRIMARY_RATE_TYPE BIS: Primary Rate Type
BIS_SECONDARY_RATE_TYPE BIS: Secondary Rate Type
BIS_PRIMARY_CURRENCY_CODE BIS: Primary Currency
BIS_SECONDARY_CURRENCY_CODE BIS: Secondary Currency
BIS_ENTERPRISE_CALENDAR BIS: Enterprise Calendar
BIS_PERIOD_TYPE BIS: Period
BIS_GLOBAL_START_DATE BIS: Global Start Date (mm/dd/yyyy)
BIS_WORKFORCE_MEASUREMENT_TYPE BIS: Workforce Measurement Type
BIS_MASTER_INSTANCE BIS: Master Instance
EDW_COLLECTION_OFFSET EDW : Collection Start Time Offset
EDW_DEBUG EDW : Debug Mode
EDW_DUPLICATE_COLLECT EDW : Duplicate Records Loaded
EDW_TRACE EDW : Trace Mode
BIS_SQL_TRACE BIS: SQL_TRACE
BIS_TREND_GRAPH_WIDTH BIS: Trend Graph Width (pixels)
PMV_USER_TYPE PMV: User Type
BIS_CSV_FILE_PATH BIS: CSV File Path
BIS_ENVIRONMENT BIS: Environment Type
BIS_RTC_URI BIS: RTC URI
BIS_RTC_SITEID BIS: RTC Site Id
EDW_DEFAULT_SECURITY EDW : Enable Default Security
BIS_PMF_DEV_ENV BIS: Oracle Development Environment
BIS_DBI_LOGO BIS: Logo on DBI Pages and Reports
BIS_DEFAULT_DRILL_ENABLED BIS: Default Drill URL Enabled
BIS_PMV_CHANGE_HIGH_RANGE BIS : High % Range
BIS_PMV_CHANGE_LOW_RANGE BIS : Low % Range
BIS_AS_OF_DATE BIS: AS OF DATE
BIS_ANNUALIZED_CURRENCY_CODE BIS: Annualized Currency
BIS_ANNUALIZED_RATE_TYPE BIS: Annualized Rate Type
BIS_TREASURY_RATE_TYPE BIS: Treasury Rate Type
BIS_CUST_CLASS_TYPE BIS: Party Market Classification Type
BIS_BIA_REQUESTSET_HISTORY BIS BIA Request set history
BIS_CUST_HIER_TYPE BIS: Customer Hierarchy Type
BIS_ANNUALIZED_CURDISP_NAME BIS: Annualized Currency Display Name
BIS_AUTO_FACTOR BIS: Auto Factoring
BIS_ENABLE_DELEGATE_LINK BIS: Enable Delegate Link
BIS_PMV_THEMES BIS Themes
BIS_MV_FORCE_REFRESH BIS : Materialized View Force Refresh
BIS_BIA_MVLOG_ENABLE BIS: Enable MV Log Management
BIS_CONF_SITEID BIS: Conference Site Id
BIS_CONF_AUTHTOKEN BIS: Conference Authentication Token
BIS_CONF_DOMAIN BIS: Conference Domain
BIS_CONF_URI BIS: Conference URI
BIS_PMV_MAIL_BASE_DN BIS: Base Domain Name Values
BIS_PMV_MAIL_LDAP_SERVER BIS: Mailing LDAP Server
BIS_PMV_MAIL_SMTP_SERVER BIS: Mailing SMTP Server
BIS_BIA_MV_INDEX_ENABLE BIS: Enable MV Index Management
BIS_PMV_AW_NAME PMV Analytical Workspace Name
BIS_SCHEDULE_TIME BIS: Schedule Time
BIS_SCHEDULE_DAY_OF_WEEK BIS: Schedule Day of Week
BIS_SCHEDULE_DATE_OF_MONTH BIS: Schedule Date of Month
BIS_RTC_AUTHTOKEN BIS: RTC Authorization Token
BIS_START_DAY_OF_WEEK BIS: Start Day of Week
BIS_TXN_COMPLEXITY_HIGH BIS Transaction Complexity Factor – High
BIS_TXN_COMPLEXITY_MEDIUM BIS Transaction Complexity Factor – Medium
BIS_TXN_COMPLEXITY_LOW BIS Transaction Complexity Factor – Low
EDW_ROLLBACK_SRC EDW : Collection Rollback Segment
EDW_AUTO_DANG_RECOVERY EDW : Auto Dangling Recovery
EDW_MAX_THREADS EDW : Max Parallel Jobs
EDW_STG_JOIN_NL EDW : Use Nested Loop (Percentage)
EDW_OK_UPDATE EDW : Use Update for OK Table (Percentage)
EDW_MIN_JOB_LOAD_SIZE EDW : Min Job Load Size (Rows)
EDW_SLEEP_TIME EDW : Sleep Time (Seconds)
BIS_LOAD_SCHEDULE BIS: Load Schedule
EDW_PUSH_SIZE EDW : Collect Commit Size