EBS_PARAMETERS App
The EBS_PARAMETERS application provides a centralized parameter configuration layer for EBS HRF mappings.
It stores default seeded assignments for the parameters that are consumed across generated .hrf files through the following code references
For example: CONFIGURATION[ETL_PARAM_VARCHAR2_4000.SOFT_DELETE_FEATURE_ENABLED] , allowing mappings to remain configurable with the default value without hard-coding values directly into each transformation.
The application has two hrfs to handle single-value and multi-value (list) parameters. SingleValueParameter.hrf is used for common ETL defaults such as tenant, datasource, product line version, language, calendar, date range, currency, exchange-rate type, and unspecified/default surrogate values. MultiValueParameter.hrf is used for supporting list-based filtering, such as ledger lists, ledger type lists, master organization values, and subledger module lists.
These parameters control behavior across SDE, SIL, and PLP mappings, including source-system selection, incremental/full load behavior, date handling, multilingual processing, ledger filtering, soft-delete logic, currency conversion, calendar derivation, and default value substitution. Because many HRF mappings depend on these values, you must review changes to EBS_PARAMETERS carefully and perform regression-tests across affected subject areas.
The following table has the list of default level parameter configuration in SingleValueParameter.hrf. This is the seeded default values given for the parameters. You can change the assignment based on the functional use case.
| Parameter Name | Description | Default Value |
|---|---|---|
|
CAL_WEEK_FLG |
NA |
P |
|
CAL_WEEK_STANDARD |
NA |
US |
|
CUSTOMER_HIERARCHY_TYPE |
NA |
CORPORATE HIERARCHY |
|
DATASOURCE_NUM_ID |
NA |
310 |
|
DATA_SERVER_CODE |
NA |
EBS_12_2 |
|
DEFAULT_LOC_RATE_TYPE |
NA |
Corporate |
|
EMPL_NAME_FORMAT |
NA |
L,F |
|
END_DATE |
NA |
31/12/30 0:00 |
|
ETL_13P_CALENDAR_ID |
NA |
10001 |
|
ETL_445P_CALENDAR_ID |
NA |
10000 |
|
ETL_PROC_WID |
NA |
1 |
|
ETL_UNSPEC_CODE |
NA |
__NOT_APPLICABLE__ |
|
ETL_UNSPEC_DATE |
NA |
01/01/01 0:00 |
|
ETL_UNSPEC_DSN |
NA |
0 |
|
ETL_UNSPEC_DT |
NA |
01/01/01 0:00 |
|
ETL_UNSPEC_HI_DT |
NA |
01/01/14 0:00 |
|
ETL_UNSPEC_LOW_DT |
NA |
1899-01-01 00:00:00 |
|
ETL_UNSPEC_NAME |
NA |
Unspecified |
|
ETL_UNSPEC_NO_FLG |
NA |
N |
|
ETL_UNSPEC_NUM |
NA |
0 |
|
ETL_UNSPEC_ROW_WID |
NA |
0 |
|
ETL_UNSPEC_STR |
NA |
Unspecified |
|
ETL_UNSPEC_YES_FLG |
NA |
Y |
|
GBL_CALENDAR_ID |
NA |
10000 |
|
GBL_DATASOURCE_NUM_ID |
NA |
999 |
|
HISTORY_MONTHS |
NA |
12 |
|
HI_DATE |
NA |
01/01/14 0:00 |
|
HI_DT |
NA |
3714-01-01 00 |
|
HR_WRKFC_DFLT_HRS_WK |
NA |
40 |
|
INITIAL_EXTRACT_DATE |
NA |
01/01/70 0:00 |
|
INV_PROD_CAT_SET_ID1 |
NA |
2 |
|
INV_PROD_CAT_SET_ID10 |
NA |
0 |
|
INV_PROD_CAT_SET_ID2 |
NA |
27 |
|
INV_PROD_CAT_SET_ID3 |
NA |
0 |
|
INV_PROD_CAT_SET_ID4 |
NA |
0 |
|
INV_PROD_CAT_SET_ID5 |
NA |
0 |
|
INV_PROD_CAT_SET_ID6 |
NA |
0 |
|
INV_PROD_CAT_SET_ID7 |
NA |
0 |
|
INV_PROD_CAT_SET_ID8 |
NA |
0 |
|
INV_PROD_CAT_SET_ID9 |
NA |
0 |
|
IS_FEDFIN_ENABLED |
NA |
N |
|
IS_TASK_ENABLED |
NA |
N |
|
LANGUAGE_BASE |
NA |
US |
|
LANGUAGE_LIST |
NA |
US |
|
LAST_ARCHIVE_DATE |
NA |
1899-01-01 00:00:00 |
|
LOW_DATE |
NA |
1899-01-01 00:00:00 |
|
ORA_HI_DATE |
NA |
31/12/12 0:00 |
|
PA_PRM_DEFAULT_CALENDAR |
NA |
0 |
|
PHASE |
NA |
3 |
|
PRODUCT_LINE_VERSION_KEY |
NA |
EBS_12_2 |
|
PROD_CAT_SET_ID1 |
NA |
2 |
|
PROD_CAT_SET_ID10 |
NA |
0 |
|
PROD_CAT_SET_ID2 |
NA |
27 |
|
PROD_CAT_SET_ID3 |
NA |
0 |
|
PROD_CAT_SET_ID4 |
NA |
0 |
|
PROD_CAT_SET_ID5 |
NA |
0 |
|
PROD_CAT_SET_ID6 |
NA |
0 |
|
PROD_CAT_SET_ID7 |
NA |
0 |
|
PROD_CAT_SET_ID8 |
NA |
0 |
|
PROD_CAT_SET_ID9 |
NA |
0 |
|
PROJ_AVLBL_BUCKET_SIZE |
NA |
5 |
|
PROJ_COMMITMENT_GRAIN |
NA |
WEEK |
|
RESTORE_AGING_IN_FULL |
NA |
Y |
|
SOFT_DELETE_FEATURE_ENABLED |
NA |
Y |
|
SOURCE_OF_DATA |
NA |
XACT |
|
SOURCE_TYPE_CODE |
NA |
DEPRECIATION |
|
START_DATE |
NA |
01/01/70 0:00 |
|
SUPPORT_REF1 |
NA |
NULL |
|
SUPPORT_REF10 |
NA |
NULL |
|
SUPPORT_REF2 |
NA |
NULL |
|
SUPPORT_REF3 |
NA |
NULL |
|
SUPPORT_REF4 |
NA |
NULL |
|
SUPPORT_REF5 |
NA |
NULL |
|
SUPPORT_REF6 |
NA |
NULL |
|
SUPPORT_REF7 |
NA |
NULL |
|
SUPPORT_REF8 |
NA |
NULL |
|
SUPPORT_REF9 |
NA |
NULL |
|
TENANT_ID |
NA |
DEFAULT |
|
VAR_ADJUSTMENT_TYPE_OBSOLETE |
NA |
AMOUNT |
|
VAR_ETL_SOURCE_CODE_NOT_SUPPLIED |
NA |
<Source Code Not Supplied> |
|
VIEW_APPLICATION_ID |
NA |
201 |
|
WH_DATASOURCE_NUM_ID |
NA |
999 |
|
WH_DATA_SERVER_CODE |
NA |
BIA |
|
WH_PRODUCT_LINE_VERSION_KEY |
NA |
BIA_11 |
|
XRATE_UPD_NUM_DAY |
NA |
30 |
|
X_CUSTOM |
NA |
0 |
The following table has the list of default level parameter configuration in MultiValueParameter.hrf. This is the seeded default values given for the list type parameters. You can change the assignment based on the functional use case.
| Parameter Name | Default Value | Comments |
|---|---|---|
|
LEDGER_ID_LIST |
_NONE_ |
By default it is given as _NONE_ which will select all the ledgers by default. |
|
LEDGER_TYPE_LIST |
_NONE_ |
By default it is given as _NONE_ which will select all the ledger_type by default. |
|
MASTER_ORG |
204 |
NA |
|
SUBLEDGER_MODULE_LIST |
222,140,200,201,707,275,10036 |
NA |