My Oracle Support Banner

Restatement Issues In T2Ts (Doc ID 2702293.1)

Last updated on AUGUST 25, 2020

Applies to:

Oracle Financial Services Data Foundation - Version 8.0.9 and later
Information in this document applies to any platform.

Goal

 The following T2Ts need to be modified to use Start/End Date instead of Latest Record Indicator. This is to enable restatements/ reruns

T2Ts : 5 T2Ts have issues :
1. T2T_STG_CARDS_CAS has joins on F_LATEST_RECORD_IND ='Y' for DIM_CREDIT_QUALITY_TYPE and DIM_NON_PERFORMING_CATEGORY tables
2. T2T_STG_LOANS_CAS has joins on F_LATEST_RECORD_IND ='Y' for DIM_CREDIT_QUALITY_TYPE and DIM_NON_PERFORMING_CATEGORY tables
3. T2T_STG_OD_CAS has joins on F_LATEST_RECORD_IND ='Y' for DIM_CREDIT_QUALITY_TYPE and DIM_NON_PERFORMING_CATEGORY tables
4. T2T_STG_LEASES_CONTRACTS_CAS has joins on F_LATEST_RECORD_IND ='Y' for DIM_CREDIT_QUALITY_TYPE and DIM_NON_PERFORMING_CATEGORY tables
5. T2T_FCT_ACCT_CREDIT_SCORE_DETAILS has LRI joins on multiple DIM tables

Solution

To view full details, sign in with your My Oracle Support account.

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

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.