My Oracle Support Banner

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.

Symptoms

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.

Cause

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
Symptoms
Cause
Solution


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