You are browsing the archive for EDW.

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

Applications BIS Concurrent Programs

Oracle Applications BIS Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
ISC_EDW_BOOKINGS_F_T Load Bookings Fact
EDW_FLEX_PUSH Collect User Defined Dimensions
EDW_BIS_VIEW_GEN Generate Business Views
EDW_COMPILE_PACKAGES Recompile Invalid Packages
EDW_GL_ACCT_M_C Collect GL Accounting Dimensions
BIS_REPORT_SCHEDULER BIS Report Scheduler
EDW_SIZE_REPORT Generate Warehouse Size Report
EDW_SIZE_WRAPPER Estimate Warehouse Size
BIS_BIA_COMPILE_INVALID_RSG_MV BIS BIA Compile Invalid RSG Mvs
EDW_REFRESH_SECURITY_METADTA Refresh EDW Metadata
EDW_ANALYZE_DIMENSION Analyze Dimension
EDW_ANALYZE_FACT Analyze Fact
EDW_CDI_FACT_C_T Check Fact Data Validity
EDW_CDI_DIM_C_T Check Dimension Data Validity
EDW_NAEDW_T Load NAEDW and ALL
EDW_INSTANCE_M_T Load Instance Dimension
EDW_DEL_DIM Purge Dimension Interface Tables
EDW_FACT_DEL Purge Fact Interface Tables
EDW_ANALYZE_TABLES Analyze Dimensions and Facts
EDW_REMOVE_POLICY Remove EDW Security Policy from Fact
EDW_ADD_POLICY Add EDW Security Policy to Fact
EDW_FLEX_COLLECT Load User Defined Dimensions
EDW_GL_ACCT_LOAD Load GL Accounting Dimensions
EDW_ANALYZE_UTIL Analyze Warehouse Tables
EDW_CLEAN_FACT_DATA Clean Fact Data
EDW_CLEAN_DIM_DATA Clean Dimension Data
EDW_DEL_DIM_DUP_DATA Delete Dimension Duplicate Data
EDW_DEL_FACT_DUP_DATA Delete Fact Duplicate Data
EDW_BOM_RES_M Collect Resource Dimension
BIS_ALERT_SERVICE BIS Alert Service
BIS_ALERT_SERVICE_PVT BIS Alert Service Private
BIS_PMF_GET_EDW_DIMENSIONS Import Data Warehouse Dimensions
EDW_OE_SLCHNL_M_T Load Sales Channel Dimension
EDW_MRP_PLAN_M_T Load Plan Name Dimension
EDW_MRP_FORECAST_M_T Load Forecast Dimension
EDW_MRP_DM_CLS_M_T Load Demand Class Dimension
BISUA_CLEANUP BIS_USER_ATTRIBUTES Table Cleanup
BISPMVCLSCBUA BIS PMV Clear Schedule and associated Parameter records
BIS_MV_DUMMY_REFRESH BIS Materialized View Batch Refresh Program for MVs not to implement
BIS_MV_REFRESH BIS Materialized View Refresh Program
BIS_ALERT_SERVICE_PVT_JAVA BIS Alert Service Private (Java)
BIS_ALERT_SERVICE_RSG BIS Alert RSG
BIS_RSG_PURGE_HISTORY_TABLE Purge Request Set Generator History Tables
BIS_LAST_REFRESH_DATE_CONC BIS Last Refresh Date Maintaining Program
BIS_BIA_RSG_LOG_MGMNT BIS RSG MV Log Management
BIS_RSG_CREATE_SNP Request Set Generator:Create Snapshot Log
BIS_DBI_UPDATE_ALL Request Set Daily Business Intelligence Update
Dimension stage Request Set Stage Dimension Concurrent Programs – Request Set Daily Business Intelligence Update
Base Summary stage Request Set Stage Base Summary Concurrent Programs – Request Set Daily Business Intelligence Update
Level 1 Summaries Request Set Stage Level 1 Summaries – Request Set Daily Business Intelligence Update
Level 2 Summaries Request Set Stage Level 2 Summaries – Request Set Daily Business Intelligence Update
DEPDIM Request Set Stage Dependant Dimensions – Request Set Daily Business Intelligence Update
DEPBS Request Set Stage Dependant Base Summaries – Request Set Daily Business Intelligence Update
BIS_MV_REFRESH_STANDALONE BIS Materialized View Standalone Refresh Program
BIS_RSG_FINAL BIS Request Set Generator Finalization Program
BIS_RSG_PREP BIS Request Set Generator Preparation Program
SET_BIS_IMPL_OPT BIS Object Implementation Flag Update
BIS_BIA_RSG_HISTORY_PROG RSG Request Set History Collection Program
BIS_BIA_STATS_TABLE BIS RSG Gather Table Statistics
BIS_MV_UTILITY_PRINT_LOG RSG Utility Program to Print Out MVs on Top of MV Logs
BIS_BIA_RSG_RECREATE_MV_INDEX Recreate MV Index
BIS_BIA_RSG_VALIDATION Request Set Generator Seed Data Validation Program
BIS_BIA_RSG_MLOG_CAD BIS RSG MV Log Capturing and Dropping Program
BIS_BIA_RSG_LOG_RESTORE BIS RSG MV Log Restoring Program
BIS_BIA_TRUNCATE_EMPTY_MV_LOGS BIS BIA RSG Truncate Empty MV Logs
BIS_BIA_RS_STATUS_CHK BIS Request Set Status Check Program
BISDBIPAGESCHEDULER BIS DBI Page Scheduler

Operations Intelligence Profile Options

Oracle Operations Intelligence Module Profile Options

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
EDW_ENABLE_INV_ACTIVITY_MEASURES EDW: Enable Inventory Activity Measures