1. User Guide
  2. Fact Ledger Population
  3. Tables Used by the Fact Ledger Population Transformation

8.2 Tables Used by the Fact Ledger Population Transformation

The Fact Ledger Population Transformation uses the following tables:

  • FSI_FISCAL_YEAR_INFO: This table has the FISCAL year info. The entries required in this table are mentioned in the Prerequisites.
  • FSI_BI_SETUP_TABLE: This table has the setup information used by the 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 FSI_D_MANAGEMENT_LEDGER 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 to FCT_LEDGER_STAT is directly available in FSI_D_MANAGEMENT_LEDGER or a join has to be taken with dimension table to get the skey.
  • FSI_D_MANAGEMENT_LEDGER: This table is the source for 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 OFS EFPA Erwin Data Model.