Configure the OILM Configuration Tables
- In the Atomic Schema, populate the FSI_OILM_CONFIGURATION_DETAILS Table as
tabulated:
Sl No Column Name Parameters 1 OBJECT_ID The serial number.
Example: 1, 2,3 for every row.
2 APP_ID The default value is OFS_OILM. 3 USER_ID The application username.
Example: OILMUSER and SYSTEM must be given as default users.
4 DIMENSION_MAP_KEY By default, the SYSTEM and USERID must be inserted with a different DIMENSION_MAP_KEY.
Example: Only Numeric values such as 1,2,3.
5 TRIANGLE_DECIMAL For the Triangle decimal column, the mandatory value should be between the ranges of 1 to 6. This table is used to map different dimension’s DIMENSION_MAP_KEY for the respective application user.
- The dimensions mapped in the dimension selection on the OILM
configuration landing page will be updated in the
FSI_OILM_CONF_DIMENSION_MAPPING table.
Sl No Column Name Parameters 1 DIMENSION_MAP_KEY The serial number.
Example: 1, 2,3 for every row.
2 DIMENSION_NAME By default for each application user, the first dimension must be the Legal Entity
The User can map 10 dimensions, including the Legal Entity Dimension, out of 20 Dimensions available in the OILM Application.
The list of Dimension can be referred to from the REV_DIMENSIONS_TL Seeded Data Table.
3 ORDER_ID For the selected 10 Dimensions, the first dimension must always be Legal Entity and the DIMENSION_MAP_KEY must be 1. This table is used to map different dimension's for the respective application user.