7.3 Tables Used by the Fact Ledger Population Transformation

Following are the tables used by the Fact Ledger Population Transformation:

• FCT_ALM_SIGNIFICANT_CURRENCY: This table helps to identify which of the currencies for a given legal entity have material exposure. It stores a list of currencies for each legal entity on the books and marks them as 'significant' if the assets or liabilities in a significant currency exceed a certain threshold. That is, as per Interest Rate Risk in Banking Book regulation a currency is considered to have 'material exposure' if it accounts for more than 5% of either banking book assets or liabilities.
• FSI_FISCAL_YEAR_INFO: This table has the FISCAL year info. The entries required in this table are mentioned in the Prerequisites section.
• FSI_BI_SETUP_TABLE: This table has the setup information used by the Fact Ledger Population Transformation. They are:
  • TARGET_TABLE_NAME: This is the destination table name for transformation.
  • TARGET_COLUMN_NAME: This is the Destination column name in the FCT_LEDGER_STAT table.
  • MEMBER_COL_NAME: This is the column Name in the LEDGER_STAT table.
  • SOURCE_DIM_TABLE_NAME: This is the dimension table to which the Ledger data has to be joined to get the surrogate key value.
  • SOURCE_COLUMN_NAME: This is the column in the dimension table to which the LEDGER STAT ID column is joined.
  • SKEY_COLUMN_NAME: This is the column in the dimension table which has the surrogate key value.
  • JOIN_REQUIRED: This provides the information, whether the column to be moved into FCT_LEDGER_STAT is directly available in LEDGER_STAT or a join must be taken with the dimension table to get the surrogate key.
• LEDGER_STAT: This table is the source of the transformation.
  • DIM_<Dimension Name>: The flattened dimension tables used in Business Intelligence (BI) reporting are accessed to obtain the surrogate key to be populated to FCT_LEDGER_STAT dimension columns. For example, DIM_ORG_UNIT, DIM_PRODUCT, and so on.
• FCT_LEDGER_STAT: This is the output table for the transformation. For more details on viewing the structure of these tables, see Oracle Financial Services Analytical Applications Data Model Data Dictionary or the ALMBI Erwin Data Model. The Custom Dimensions can be added to the target table, FCT_LEDGER_STAT by updating the configuration table FSI_BI_SETUP_TABLE.
• DIM_LOB and DIM_ORG_STRUCTURE are two Custom Dimension tables, for which the dimension data must be entered manually during implementation.