EBS_CONFIG App

The EBS_CONFIG app provides the shared configuration framework for EBS global, fact, and dimension group-level settings.

It centralizes configuration values that control how subject areas, facts, dimensions, domains, and common processing rules behave across the HRF mapping layer.

The following table has the list of configurable parameters used in the DA applications and defines which parameters are associated with specific fact groups and dimension groups and how to configure the same. Each row represents a parameter assignment, including the parameter code, display name, description, value type, data type, source/application context, task code, and the functional group where the parameter applies.

The key group-related columns are:

PARAM_CODE - The configuration parameter name.

GROUP_TYPE - Identifies whether the parameter belongs to a FACT_GROUP (Fact group) or DIMEN_GROUP (Dimension Group).

GROUP_CODE - The fact group or dimension group code linked to the parameter.

GROUP_NAME - Description of the fact group or dimension group.

By default EBS_CONFIG app >> Console_Configurations.hrf >>C_PARAMETER_VALUE_FORMATTER_V_DS_IN inline dataset has the seeded configuration for the parameters. The parameter can be configured globally, fact group/dim group level.

Global - The parameter configuration applies globally to all the mappings where it is used irrespective of the fact/dim group.

Fact/Dim Group - The parameter configuration applies to the specific fact/dimension group and applies to all the mappings which are tied to this group.

For example: Here for the parameter SOFT_DELETE_PREPROCESS it is set as Y for GLSEG_DIM. This parameter will be enabled only for the mappings in GLSEG_DIM and for all the other mappings it will be treated as N.

For example:

SLNo:	PARAM_CODE	GROUP_TYPE	GROUP_CODE	GROUP_NAME
1	COST_TIME_GRAIN	FACT_GROUP	PRJCOST_FG	Project Cost
2	HISTORY_LOAD	FACT_GROUP	APTRANS_FG	AP Transactions and Balance
3	HISTORY_LOAD	FACT_GROUP	ARTRANS_FG	AR Transactions and Balance
4	NAME_ORDER_WITH_FIRSTNAME	DIMEN_GROUP	POSHIER_DIM	Position Hierarchy Dimension
5	NAME_ORDER_WITH_FIRSTNAME	GLOBAL	GLOBAL	Global
6	PROJ_GL_PERIODS_TO_LOAD	FACT_GROUP	PRJGLRECNCL_FG	Project GL Reconciliation
7	PROJ_GL_PERIODS_TO_LOAD	GLOBAL	GLOBAL	Global
8	PROJ_GL_RECON_DT	FACT_GROUP	PRJGLRECNCL_FG	Project GL Reconciliation
9	PROJ_GL_RECON_DT	GLOBAL	GLOBAL	Global
10	REVENUE_TIME_GRAIN	FACT_GROUP	PRJREVN_FG	Project Revenue
11	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	BALSEG_DIM	Balancing Segment Dimension
12	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	BUSNLOC_DIM	Business Location Dimension
13	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	CHLTYPE_DIM	Channel Type Dimension
14	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	COSTCTR_DIM	Cost Center Dimension
15	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	CUSTACCT_DIM	Customer Account Dimension
16	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	CUSTLOC_DIM	Customer Location Dimension
17	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	EMPLOYEE_DIM	Employee Dimension
18	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	GLSEG_DIM	GL Segment Dimension
19	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	INDUSTRY_DIM	Industry Dimension
20	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	INTORG_DIM	Internal Organization Dimension
21	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	INVPROD_DIM	Inventory Product Dimension
22	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	NAT_ACCT_DIM	Natural account Dimension
23	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	PARTYPER_DIM	Party Person Dimension
24	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	PARTY_DIM	Party Dimension
25	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	POSHIER_DIM	Position Hierarchy Dimension
26	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	PRODCAT_DIM	Product category Dimension
27	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	PRODUCT_DIM	Product Dimension
28	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	SUPACCT_DIM	Supplier Account Dimension
29	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	TERR_DIM	Territory Dimension
30	SOFT_DELETE_PREPROCESS	DIMEN_GROUP	USER_DIM	User Dimension
31	SOFT_DELETE_PREPROCESS	FACT_GROUP	APHOLDS_FG	AP Holds
32	SOFT_DELETE_PREPROCESS	FACT_GROUP	APTRANS_FG	AP Transactions and Balance
33	SOFT_DELETE_PREPROCESS	FACT_GROUP	ARTRANS_FG	AR Transactions and Balance
34	SOFT_DELETE_PREPROCESS	FACT_GROUP	ASTBAL_FG	Fixed Asset Balances
35	SOFT_DELETE_PREPROCESS	FACT_GROUP	ASTXACT_FG	Fixed Asset Transactions
36	SOFT_DELETE_PREPROCESS	FACT_GROUP	EXPCRDTCRD_FG	Expense Credit Card
37	SOFT_DELETE_PREPROCESS	FACT_GROUP	EXPOVERVIEW_FG	Expense Overview
38	SOFT_DELETE_PREPROCESS	FACT_GROUP	EXPVIOLATION_FG	Expense Violation
39	SOFT_DELETE_PREPROCESS	FACT_GROUP	FINPROFL_FG	Financial Profile
40	SOFT_DELETE_PREPROCESS	FACT_GROUP	PONNEG_FG	Sourcing Negotiation
41	SOFT_DELETE_PREPROCESS	FACT_GROUP	PONRESP_FG	Sourcing Response
42	SOFT_DELETE_PREPROCESS	FACT_GROUP	PRJBILLING_FG	Project Billing
43	SOFT_DELETE_PREPROCESS	FACT_GROUP	PRJBUDGET_FG	Project Budget
44	SOFT_DELETE_PREPROCESS	FACT_GROUP	PRJCIP_FG	Project CIP
45	SOFT_DELETE_PREPROCESS	FACT_GROUP	PRJCOST_FG	Project Cost
46	SOFT_DELETE_PREPROCESS	FACT_GROUP	PRJCRSCHRG_FG	Project Cross Charge
47	SOFT_DELETE_PREPROCESS	FACT_GROUP	PRJFRCST_FG	Project Forecast
48	SOFT_DELETE_PREPROCESS	FACT_GROUP	PRJFUNDING_FG	Project Funding
49	SOFT_DELETE_PREPROCESS	FACT_GROUP	PRJREVN_FG	Project Revenue
50	SOFT_DELETE_PREPROCESS	FACT_GROUP	PRJRSRCMGMT_FG	Project Resource Management
51	SOFT_DELETE_PREPROCESS	FACT_GROUP	PROCPO_FG	Procurement Purchase Orders
52	SOFT_DELETE_PREPROCESS	FACT_GROUP	PROCPURRCPT_FG	Purchase Receipts
53	SOFT_DELETE_PREPROCESS	FACT_GROUP	PROCPURREQ_FG	Purchase Requisitions
54	SOFT_DELETE_PREPROCESS	FACT_GROUP	PURAGG_FG	Purchasing Aggregate
55	SOFT_DELETE_PREPROCESS	FACT_GROUP	SPEND_FG	Spend
56	SOFT_DELETE_PREPROCESS	GLOBAL	GLOBAL	Global
57	TIME_GRAIN	FACT_GROUP	PROCPURCY_FG	Purchase Cycle
58	TIME_GRAIN	FACT_GROUP	PROCPURRCPT_FG	Purchase Receipts
59	TYPE2_FLG	DIMEN_GROUP	BUSNLOC_DIM	Business Location Dimension
60	TYPE2_FLG	DIMEN_GROUP	CUSTLOC_DIM	Customer Location Dimension
61	TYPE2_FLG	DIMEN_GROUP	EMPLOYEE_DIM	Employee Dimension
62	TYPE2_FLG	DIMEN_GROUP	PARTY_DIM	Party Dimension
63	TYPE2_FLG	DIMEN_GROUP	POSHIER_DIM	Position Hierarchy Dimension
64	TYPE2_FLG	DIMEN_GROUP	USER_DIM	User Dimension
65	TYPE2_FLG	GLOBAL	GLOBAL	Global
66	FSCL_PERIODS_TO_REFRESH	GLOBAL	GLOBAL	Global
67	FSCL_PERIODS_TO_REFRESH	FACT_GROUP	GLJRNLS_FG	GL Journals
68	FSCL_PERIODS_TO_REFRESH	FACT_GROUP	ARTRANS_FG	AR Transactions and Balance
69	FSCL_PERIODS_TO_REFRESH	FACT_GROUP	APTRANS_FG	AP Transactions and Balance

Global Currencies

By default, seeded values are provided for the global currencies. Global currencies enable users to analyze financial data across multiple business units and regions by converting transactions into a common reporting currency.

Review the seeded values and update them as required to meet your organization’s reporting requirements.

Navigation:

EBS_CONFIG → Console_Configurations.hrf → C_DWGLOBAL_PARAMS_VL_DS_IN (inline dataset)

PARAM_CODE	Default Value
GLOBAL1_CURR_CODE_DOMAIN	USD
GLOBAL1_RATE_TYPE_DOMAIN	Corporate
GLOBAL2_CURR_CODE_DOMAIN	EUR
GLOBAL2_RATE_TYPE_DOMAIN	Corporate
GLOBAL3_CURR_CODE_DOMAIN	GBP
GLOBAL3_RATE_TYPE_DOMAIN	Corporate
GLOBAL4_CURR_CODE_DOMAIN	USD
GLOBAL4_RATE_TYPE_DOMAIN	Corporate
GLOBAL5_CURR_CODE_DOMAIN	USD
GLOBAL5_RATE_TYPE_DOMAIN	Corporate
DEFAULT_LOC_RATE_TYPE_DOMAIN	Corporate

Note:

For the target table and fact or dim group assignment, refer Fact and Dimension Group Usage by Target Table.