Configure the Pipeline Parameters
Configure the Pipeline Parameters as follows:
- In Oracle Fusion Data Intelligence, navigate to the Data Applications page.
- Open the EBS_PARAMETERS application, navigate to the following mapping files, and configure the required parameters:
-
SingleValueParameter.hrf
-
MultiValueParameter.hrf
-
| Application Name | Console Param | Pipeline Param |
|---|---|---|
|
EBS_CONFIG |
NA |
DATASOURCE_NUM_ID |
|
EBS_DOMAINS |
NA |
LANGUAGE_LIST |
|
EBS_DOMAINS |
NA |
LANGUAGE_BASE |
|
EBS_DOMAINS |
NA |
ETL_UNSPEC_DSN |
|
EBS_DOMAINS |
NA |
TENANT_ID |
|
EBS_COMMON |
NAME_ORDER_WITH_FIRSTNAME |
START_DATE |
|
EBS_COMMON |
FSCL_PERIODS_TO_REFRESH |
END_DATE |
|
EBS_COMMON |
TYPE2_FLG |
INITIAL_EXTRACT_DATE |
|
EBS_COMMON |
SOFT_DELETE_PREPROCESS |
LAST_ARCHIVE_DATE |
|
EBS_COMMON |
GLOBAL1_CURR_CODE_DOMAIN |
HI_DATE |
|
EBS_COMMON |
GLOBAL2_CURR_CODE_DOMAIN |
LOW_DATE |
|
EBS_COMMON |
GLOBAL3_CURR_CODE_DOMAIN |
ORA_HI_DATE |
|
EBS_COMMON |
GLOBAL4_CURR_CODE_DOMAIN |
LEDGER_ID_LIST |
|
EBS_COMMON |
GLOBAL5_CURR_CODE_DOMAIN |
LEDGER_TYPE_LIST |
|
EBS_COMMON |
GLOBAL1_RATE_TYPE_DOMAIN |
MASTER_ORG |
|
EBS_COMMON |
GLOBAL2_RATE_TYPE_DOMAIN |
SUBLEDGER_MODULE_LIST |
|
EBS_COMMON |
GLOBAL3_RATE_TYPE_DOMAIN |
CAL_WEEK_FLG |
|
EBS_COMMON |
GLOBAL4_RATE_TYPE_DOMAIN |
CAL_WEEK_STANDARD |
|
EBS_COMMON |
GLOBAL5_RATE_TYPE_DOMAIN |
GBL_CALENDAR_ID |
|
EBS_COMMON |
DEFAULT_LOC_RATE_TYPE_DOMAIN |
ETL_13P_CALENDAR_ID |
|
EBS_COMMON |
NA |
ETL_445P_CALENDAR_ID |
|
EBS_COMMON |
NA |
INV_PROD_CAT_SET_ID1 – INV_PROD_CAT_SET_ID10 |
|
EBS_COMMON |
NA |
PROD_CAT_SET_ID1 – PROD_CAT_SET_ID10 |
|
EBS_COMMON |
NA |
CUSTOMER_HIERARCHY_TYPE |
|
EBS_COMMON |
NA |
GBL_DATASOURCE_NUM_ID |
|
EBS_COMMON |
NA |
EMPL_NAME_FORMAT |
|
EBS_COMMON |
NA |
IS_FEDFIN_ENABLED |
|
EBS_COMMON |
NA |
XRATE_UPD_NUM_DAY |
|
EBS_COMMON |
NA |
ETL_PROC_WID |
|
EBS_COMMON |
NA |
ETL_UNSPEC_DSN |
|
EBS_COMMON |
NA |
ETL_UNSPEC_NUM |
|
EBS_COMMON |
NA |
ETL_UNSPEC_DT |
|
EBS_COMMON |
NA |
ETL_UNSPEC_NO_FLG |
|
EBS_COMMON |
NA |
ETL_UNSPEC_ROW_WID |
|
EBS_COMMON |
NA |
ETL_UNSPEC_STR |
|
EBS_COMMON |
NA |
ETL_UNSPEC_YES_FLG |
|
EBS_COMMON |
NA |
VAR_ETL_SOURCE_CODE_NOT_SUPPLIED |
|
EBS_COMMON |
NA |
VIEW_APPLICATION_ID |
|
EBS_COMMON |
NA |
DEFAULT_LOC_RATE_TYPE |
|
EBS_COMMON |
NA |
SOFT_DELETE_FEATURE_ENABLED |
|
EBS_GL |
NA |
LEDGER_ID_LIST |
|
EBS_GL |
NA |
LEDGER_TYPE_LIST |
|
EBS_AP |
FSCL_PERIODS_TO_REFRESH |
HISTORY_MONTHS |
|
EBS_AP |
SOFT_DELETE_PREPROCESS |
INITIAL_EXTRACT_DATE |
|
EBS_AP |
HISTORY_LOAD |
LAST_ARCHIVE_DATE |
|
EBS_AP |
NA |
RESTORE_AGING_IN_FULL |
|
EBS_AP |
NA |
ETL_UNSPEC_HI_DT |
|
EBS_AP |
NA |
ETL_UNSPEC_LOW_DT |
|
EBS_AP |
NA |
SOFT_DELETE_FEATURE_ENABLED |
|
EBS_AR |
FSCL_PERIODS_TO_REFRESH |
HISTORY_MONTHS |
|
EBS_AR |
SOFT_DELETE_PREPROCESS |
INITIAL_EXTRACT_DATE |
|
EBS_AR |
HISTORY_LOAD |
LAST_ARCHIVE_DATE |
|
EBS_AR |
NA |
RESTORE_AGING_IN_FULL |
|
EBS_AR |
NA |
ETL_UNSPEC_HI_DT |
|
EBS_AR |
NA |
ETL_UNSPEC_LOW_DT |
|
EBS_AR |
NA |
SOFT_DELETE_FEATURE_ENABLED |
|
EBS_AR |
NA |
ETL_UNSPEC_NUM |
|
EBS_AR |
NA |
DEFAULT_LOC_RATE_TYPE |
|
EBS_EE |
SOFT_DELETE_PREPROCESS |
INITIAL_EXTRACT_DATE |
|
EBS_EE |
NA |
LAST_ARCHIVE_DATE |
|
EBS_EE |
NA |
SOFT_DELETE_FEATURE_ENABLED |
|
EBS_EE |
NA |
DEFAULT_LOC_RATE_TYPE |
|
EBS_FA |
SOFT_DELETE_PREPROCESS |
INITIAL_EXTRACT_DATE |
|
EBS_FA |
NA |
LAST_ARCHIVE_DATE |
|
EBS_FA |
NA |
HI_DATE |
|
EBS_FA |
NA |
LOW_DATE |
|
EBS_FA |
NA |
HI_DT |
|
EBS_FA |
NA |
SOFT_DELETE_FEATURE_ENABLED |
|
EBS_FA |
NA |
SOURCE_OF_DATA |
|
EBS_FA |
NA |
SOURCE_TYPE_CODE |
|
EBS_FA |
NA |
VAR_ADJUSTMENT_TYPE_OBSOLETE |
|
EBS_FA |
NA |
DEFAULT_LOC_RATE_TYPE |
|
EBS_SLA |
NA |
LEDGER_ID_LIST |
|
EBS_SLA |
NA |
LEDGER_TYPE_LIST |
|
EBS_SLA |
NA |
SUBLEDGER_MODULE_LIST |
|
EBS_SLA |
NA |
INITIAL_EXTRACT_DATE |
|
EBS_SLA |
NA |
SUPPORT_REF1 to SUPPORT_REF10 |
|
EBS_PR |
SOFT_DELETE_PREPROCESS |
FSCL_PERIODS_TO_REFRESH |
|
EBS_PR |
NA |
INITIAL_EXTRACT_DATE |
|
EBS_PR |
NA |
LAST_ARCHIVE_DATE |
|
EBS_PR |
NA |
HI_DATE |
|
EBS_PR |
NA |
VAR_ETL_SOURCE_CODE_NOT_SUPPLIED |
|
EBS_PR |
NA |
SOFT_DELETE_FEATURE_ENABLED |
|
EBS_PR |
NA |
DEFAULT_LOC_RATE_TYPE |
|
EBS_PROC |
TIME_GRAIN |
MASTER_ORG |
|
EBS_PROC |
SOFT_DELETE_PREPROCESS |
INITIAL_EXTRACT_DATE |
|
EBS_PROC |
NA |
LAST_ARCHIVE_DATE |
|
EBS_PROC |
NA |
ETL_UNSPEC_NUM |
|
EBS_PROC |
NA |
PHASE |
|
EBS_PROC |
NA |
HI_DATE |
|
EBS_PROC |
NA |
LOW_DATE |
|
EBS_PROC |
NA |
SOFT_DELETE_FEATURE_ENABLED |
|
EBS_PROC |
NA |
DEFAULT_LOC_RATE_TYPE |
|
EBS_PROJECTS |
SOFT_DELETE_PREPROCESS |
HR_WRKFC_DFLT_HRS_WK |
|
EBS_PROJECTS |
PROJ_GL_RECON_DT |
PA_PRM_DEFAULT_CALENDAR |
|
EBS_PROJECTS |
PROJ_GL_PERIODS_TO_LOAD |
PROJ_AVLBL_BUCKET_SIZE |
|
EBS_PROJECTS |
COST_TIME_GRAIN |
INITIAL_EXTRACT_DATE |
|
EBS_PROJECTS |
REVENUE_TIME_GRAIN |
LAST_ARCHIVE_DATE |
|
EBS_PROJECTS |
NA |
IS_TASK_ENABLED |
|
EBS_PROJECTS |
NA |
PROJ_COMMITMENT_GRAIN |
|
EBS_PROJECTS |
NA |
ETL_UNSPEC_NUM |
|
EBS_PROJECTS |
NA |
HI_DATE |
|
EBS_PROJECTS |
NA |
LOW_DATE |
|
EBS_PROJECTS |
NA |
ORA_HI_DATE |
|
EBS_PROJECTS |
NA |
ETL_UNSPEC_STR |
|
EBS_PROJECTS |
NA |
SOFT_DELETE_FEATURE_ENABLED |
|
EBS_PROJECTS |
NA |
DEFAULT_LOC_RATE_TYPE |