Inconsistent Usage Of D_MATURITY_DATE Across T2Ts For Fact Loan Account Summary
(Doc ID 2730214.1)
Last updated on NOVEMBER 24, 2020
Applies to:Oracle Financial Services - Regulatory Reporting for US Federal Reserve - Lombard Risk Integration Pack - Version 8.0.8 and later
Information in this document applies to any platform.
Inconsistent usage of D_MATURITY_DATE across T2Ts for Fact Loan Account Summary
The mapping of Stage PP Tables (OD/Loans/Leases) column D_MATURITY_DATE is inconsistent across the T2Ts to populate Fact Loan Account Summary (FLAS).
- FLAS.N_MATURITY_DATE_SKEY is populated from Stg OD/Leases using D_MATURITY_DATE however in T2T for Stg Loans the Column D_EFF_MATURITY_DATE is used which is incorrect/inconsistent.
Further, the population of FLAS.N_REMAINING_TERM_MON and N_REMAIN_TERM_BEFORE_MODFCTN for all the Stg PP Tables (OD/Leases/Loans) use D_MATURITY_DATE only that shows that this field only needs to be used for maturity/remaining term/remaining term before modification.
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