Missing T2T Extracts for FSI_D_GUARANTEES, FSI_D_PAYMENT_SCHEDULE and FSI_D_DERIVATIVES in OFSAA 5.2 (Doc ID 1302442.1)

Last updated on OCTOBER 02, 2015

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.2

Goal

Question 1: T2T mappings do not exist for some tables

Would they be included in the distributed package? Do we need to create them from scratch?

STG_GUARANTEES -> FSI_D_GUARANTEES
STG_PAYMENT_SCHEDULE -> FSI_D_PAYMENT_SCHEDULE
STG_MUTUAL_FUNDS -> FSI_D_MUTUAL_FUNDS T2T

Question 2: T2T Process for FSI_D_DERIVATIVES

It looks like the T2T process that can be used to load FSI_D_DERIVATIVES includes the data to be loaded from STG_SWAPS to FSI_D_SWAPS and from FSI_D_SWAPS to FSI_D_DERIVATIVES. This is only one of the three flows that feed FSI_D_DERIVATIVES table, others are through FORWARD_RATE_AGMTS and OPTIONS tables.  Is it allowed to create a custom STG_DERIVATIVES table and create a T2T mapping from this table to the FSI_D_DERIVATIVES table?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms