1. User Guide
  2. Data Loaders
  3. Instrument Summary Table
  4. Mapping To OFSAA Summary Table

5.9.1 Mapping To OFSAA Summary Table

The following are the pre-defined T2T mappings between FSI_D_< XXX > tables to FSI_D_INST_SUMMARY tables:

  • T2T_INS_SUMM_ANNUITY
  • T2T_INS_SUMM_BORROWINGS
  • T2T_INS_SUMM_BREAK_FUND_CHG
  • T2T_INS_SUMM_CASA
  • T2T_INS_SUMM_CREDIT_CARDS
  • T2T_INS_SUMM_CREDIT_LINES
  • T2T_INS_SUMM_GUARANTEES
  • T2T_INS_SUMM_INVESTMENTS
  • T2T_INS_SUMM_LDGR_STAT_INST
  • T2T_INS_SUMM_LEASES
  • T2T_INS_SUMM_LOANS
  • T2T_INS_SUMM_MERCHANT_CARDS
  • T2T_INS_SUMM_MM_CONTRACTS
  • T2T_INS_SUMM_MORTGAGES
  • T2T_INS_SUMM_MRTGAGE_BCK_SC
  • T2T_INS_SUMM_MUTUAL_FUNDS
  • T2T_INS_SUMM_OTHER_SERVICES
  • T2T_INS_SUMM_RETIREMENT_ACC
  • T2T_INS_SUMM_TERM_DEPOSITS
  • T2T_INS_SUMM_TRUSTS

User can view the extract definitions by going through the following steps:

  1. Go to Data Integrator and select Source Designer, and then select Define Extracts.
  2. Under FUSION_APPSapplication, click Data Source name.
  3. Click on any of the T2T definition to view the extract definition. User can view the mapping definitions by going through the following steps:
  4. Go to Data Integrator and select Warehouse Designer, and then select Define Mapping.
  5. Under FUSION_APPS application, click Data Source Name.
  6. Click on any of the T2T definition to view the mapping definition.