Review and Configure the Parameters

Review the parameters and their usage by application. You must configure certain parameters because Oracle E-Business Suite Data Intelligence references and uses them during mapping execution.

The following table lists all the parameters used by Oracle E-Business Suite Data Intelligence, along with their purpose:
Parameter Name Description

MASTER_ORG

This parameter is used to define Master Inventory Organizations.

PROD_CAT_SET_ID1,PROD_CAT_SET_ID2,

PROD_CAT_SET_ID3,PROD_CAT_SET_ID4,

PROD_CAT_SET_ID5,PROD_CAT_SET_ID6,

PROD_CAT_SET_ID7,PROD_CAT_SET_ID8,

PROD_CAT_SET_ID9,PROD_CAT_SET_ID10

These parameters are used to Configure product category Set Set IDs. The system currently supports ten Inventory product category set IDs.

INV_PROD_CAT_SET_ID1,INV_PROD_CAT_SET_ID2,

INV_PROD_CAT_SET_ID3,INV_PROD_CAT_SET_ID4,

INV_PROD_CAT_SET_ID5,INV_PROD_CAT_SET_ID6,

INV_PROD_CAT_SET_ID7,INV_PROD_CAT_SET_ID8,

INV_PROD_CAT_SET_ID9,INV_PROD_CAT_SET_ID10

These parameters are used to Configure Inventory product category Set IDs. The system currently supports ten Inventory product category set IDs.

GLOBAL1_CURR_CODE_DOMAIN,GLOBAL2_CURR_CODE_DOMAIN,

GLOBAL3_CURR_CODE_DOMAIN,GLOBAL4_CURR_CODE_DOMAIN,

GLOBAL5_CURR_CODE_DOMAIN

These parameters are used to Configure Global currencies. Total Five global currencies need to be configured. In reporting we support three global currencies.

GLOBAL1_RATE_TYPE_DOMAIN,GLOBAL2_RATE_TYPE_DOMAIN,

GLOBAL3_RATE_TYPE_DOMAIN,GLOBAL4_RATE_TYPE_DOMAIN,

GLOBAL5_RATE_TYPE_DOMAIN

These parameters are used to Configure Global currency exchange rates. Total Five global currency exchange rate types need to be configured. These rates convert local currencies into configured Global Currencies.

ETL_UNSPEC_ROW_WID

This parameter is used to configure default value for ROW_WID if actual column does not having any value.

ETL_UNSPEC_CODE

This parameter is used to configure default value for %CODE columns if actual column does not having any value.

ETL_UNSPEC_NUM

This parameter is used to configure default value for NUMBER columns if actual column does not having any value.

ETL_UNSPEC_DSN

This parameter is used to configure default value for DSN column if actual column does not having any value.

ETL_UNSPEC_NAME

This parameter is used to configure default value for CHAR columns if actual column does not having any value.

ETL_UNSPEC_STR

This parameter is used to configure default value for CHAR columns if actual column does not having any value.

ETL_UNSPEC_YES_FLG

This parameter is used to configure default value for FLAG columns if actual column does not having any value.

ETL_UNSPEC_NO_FLG

This parameter is used to configure default value for FLAG columns if actual column does not having any value.

ETL_UNSPEC_DT

This parameter is used to configure default value for DATE columns if actual column does not having any value.

ETL_UNSPEC_DATE

This parameter is used to configure default value for DATE columns if actual column does not having any value.

ETL_UNSPEC_HI_DT

This parameter is used to configure default High date value for columns if actual column does not having any value.

ETL_UNSPEC_LOW_DT

This parameter is used to configure default low date value for columns if actual column does not having any value.

START_DATE

This parameter is used to configure Start date for the Gregorian Calendar.

END_DATE

This parameter is used to configure End date for the Gregorian Calendar.

ETL_13P_CALENDAR_ID

This parameter is used to configure Calendar ID of the 13 Period Calendar row provided in the configuration inline dataset - FILE_MCAL_CONFIG_G.

ETL_445P_CALENDAR_ID

This parameter is used to configure Calendar ID of the 4-4-5 Period Calendar row provided in the configuration inline dataset - FILE_MCAL_CONFIG_G.

CAL_WEEK_FLG

This parameter is used to configure whether the calendar week configuration is Full - "F" or partial - "P". A full week spans gregorian year boundaries. Partial week config means the week that spans Gregorian boundaries get broken into 2.

CAL_WEEK_STANDARD

This parameter is used to configure the day of week of a date and the calendar week to which that date belongs to.

There are 4 major standards that have been implemented:
  1. 'US' -- US standard
  2. 'ISO~EURO' -- Euro standard
  3. 'EURO~GER' -- German standard
  4. 'ISLAMIC' -- Islamic standard If no value is specified the US standard is taken by default.

GBL_CALENDAR_ID

This parameter is used to configure the Calendar Id that will be used as Enterprise Calendar. For Generated Calendars: enter <CALENDAR_ID>.

GBL_DATASOURCE_NUM_ID

This parameter is used to configure the DSN value for Global calendar defined.

DEFAULT_LOC_RATE_TYPE

This parameter is used to configure default local currency rate type.

DEFAULT_LOC_RATE_TYPE_DOMAIN

This parameter is used to configure default local currency rate type.

CUSTOMER_HIERARCHY_TYPE

This parameter is used to configure Customer Hierarchy Type used for EBS Party Hierarchy extract.

IS_FEDFIN_ENABLED

This parameter is used to configure whether Federal Financials is implemented or not. Set the value of this parameter to "Y" if you implement Federal Financials Analytics.

LEDGER_ID_LIST

This parameter is used to configure the list of ledgers to be extracted from source system.

LEDGER_TYPE_LIST

This parameter is used to configure the list of ledger types to be extracted from source system.

SUBLEDGER_MODULE_LIST

This parameter is used to configure the subledger modules you want to extract the GL Linkage information for.

NAME_ORDER_WITH_FIRSTNAME

This parameter is used to configure the Order of First and Last Name (used in Position Hierarchy) - Y or N. If the value is Y, then the format is "First Name Last Name", if the value is N, then the format is "Last Name First Name".

EMPL_NAME_FORMAT

This parameter is used to configure the full name format of employees. For example, --L,F --L,M,F, --L F.

SOFT_DELETE_FEATURE_ENABLED

This parameter is used to configure soft deletes on warehouse for the source deleted records.

SOFT_DELETE_PREPROCESS

This parameter is used to configure soft deletes on warehouse for the source deleted records.

LOW_DATE

This parameter is used to configure the low date value.

HI_DATE/HI_DT

This parameter is used to configure the HI date value.

ORA_HI_DATE

This parameter is used to configure the HI date value.

XRATE_UPD_NUM_DAY

This parameter is used to configure Exchange Rate EBS Incremental Logic. The default value is 30 viz one month.

FSCL_PERIODS_TO_REFRESH

This parameter is used to configure the number of fiscal periods to be deleted and reprocessed in the incremental run for aggregate tables in financial analytics. The default value is set to 12 fiscal periods.

LANGUAGE_BASE

This parameter is used to provide pseudo translations for the languages enabled on the data warehouse, but no data is available in the source system. Default value is American English.

TYPE2_FLG

This parameter is used to configure SCD type2 behaviour.

VIEW_APPLICATION_ID

This parameter is used to configure the application Id's of source system to be extracted.

VAR_ETL_SOURCE_CODE_NOT_SUPPLIED

This parameter is used to configure a default value when the source system code is not supplied.

INITIAL_EXTRACT_DATE

This parameter is used to configure the start date for historical data loading during a full ETL load.

LAST_ARCHIVE_DATE

This parameter is used to configure the last archive date used by the soft delete process.

DATASOURCE_NUM_ID

This parameter is used to uniquely identify the source system from which data is extracted.

WH_DATASOURCE_NUM_ID

This parameter is used to uniquely identify the data warehouse where the target data resides. Default value is 999.

TENANT_ID

This parameter is used to configure the system column TENANT_ID, which is used to identify individual tenants in a multi-tenant environment. The default value is set to DEFAULT.

X_CUSTOM

This parameter is used as a generic field for customer extensions. Default value is 0.

ETL_PROC_WID

This parameter configures the system column ETL_PROC_WID, which serves as a unique identifier for a specific ETL process. Default value is 1.

LANGUAGE_LIST

This parameter is used to configure the list of languages that will be used to extract translated data from source. The language codes used should be source specific.

PRODUCT_LINE_VERSION_KEY

This parameter is used to identify the specific version of the product line associated with a data source. For Oracle E-Business Suite Data Intelligence it will be "12_2_2".

DATA_SERVER_CODE

This parameter is used to configure a unique code that identifies a specific data server. For Oracle E-Business Suite Data Intelligence it will be '12_2_2'

HISTORY_MONTHS

This parameter is used to configure the number of historical monthly snapshots that will be maintained for AP and AR Aging.

HISTORY_LOAD

This parameter is used to configure whether initial balance records are collected and stored during the initial load for Accounts Payable (AP) and Accounts Receivable (AR) transactions.

AP and AR balances are calculated using the transaction records available in the corresponding base fact tables. The transaction records loaded into these fact tables during the initial load are controlled by the INITIAL_EXTRACT_DATE parameter.

If the INITIAL_EXTRACT_DATE is configured such that historical transactions are excluded from extraction, the calculated AP/AR balance amounts may be inaccurate. To ensure correct balance calculations, it is recommended to load the initial balance records into the fact tables by setting this parameter to "Y".

RESTORE_AGING_IN_FULL

This parameter is used to enable or disable the Financial Aging Snapshots backup and restore feature during a full load.

  • Set the parameter to "Y" to restore older snapshots after the full ETL process.

  • Set the parameter to "N" if you don't want older snapshots to be restored.

This parameter applies to both Accounts Payable and Accounts Receivable Aging snapshots.

SUPPORT_REF1,SUPPORT_REF2,SUPPORT_REF3,SUPPORT_REF4,

SUPPORT_REF5,SUPPORT_REF6,SUPPORT_REF7,SUPPORT_REF8,

SUPPORT_REF9,SUPPORT_REF10

This parameter is used to configure supporting references for Oracle E-Business Suite Data Intelligence. Defining supporting reference parameters is optional. You need to specify this only when you use supporting references in Oracle E-Business Suite Data Intelligence and want to analyze supporting references data in Financial Analytics.

SOURCE_OF_DATA

This parameter is used to configure the source system from which data is extracted into the data warehouse. Default value is XACT.

SOURCE_TYPE_CODE

This parameter is used to configure the source transaction type code. Default value is DEPRECIATION.

VAR_ADJUSTMENT_TYPE_OBSOLETE

This parameter is used to configure the adjustment type for obsolete inventory. Default value is AMOUNT.

TIME_GRAIN

This parameter is used to configure the time granularity at which data is processed and stored in the data warehouse. Default value is MONTH.

HR_WRKFC_DFLT_HRS_WK

This parameter used to configure the Number of working hours per week to assign as a default value if none are specified at an individual or organization level. Default is 40. 

PROJ_GL_RECON_DT

This parameter is used to configure Projects GL Reconciliation Date. Default value will be DEFAULT.

PA_PRM_DEFAULT_CALENDAR

This parameter is used to configure the profile value assigned in the Oracle E-Business Suite Data Intelligence database that corresponds to PA_PRM_DEFAULT_CALENDAR

PROJ_GL_PERIODS_TO_LOAD

This parameter is used to configure the number of periods to be loaded into the Project GL Reconciliation Fact during the pipeline process.

PROJ_AVLBL_BUCKET_SIZE

This parameter is used to configure Project Availability Bucket Size.

COST_TIME_GRAIN

This parameter is used to configure the time grain for Project Cost Aggregate Fact.

REVENUE_TIME_GRAIN

This parameter is used to configure the time grain for Project Revenue Aggregate Fact.

PROJ_COMMITMENT_GRAIN

This parameter is used to configure the time grain for Project Commitment Snapshot Fact.

IS_TASK_ENABLED

This parameter is used to configure whether Task Dimension support is enabled for Project Resource Management. Set this parameter to "Y" to enable Task Dimension support.

PHASE

This parameter is used to configure receipt count or phase indicator. Default value is 1.