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 laterInformation 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 |