My Oracle Support Banner

Inconsistent Source Attributes Mapped To Age On Book In Various T2Ts (Doc ID 2682797.1)

Last updated on JUNE 25, 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

REG REP USFED- 808

Report- FRY-14Q

Schedule- A3-Detail
------------------------------------------------------------
For mapping Age on book attribute i.e. FCT_COMMON_ACCOUNT_SUMMARY.N_AGE_ON_BOOK, T2T uses below expression given for each source table :

The mapping is not consistent across each source tables


1).TRUNC(MONTHS_BETWEEN(STG_TRUSTS.FIC_MIS_DATE,STG_TRUSTS.D_ACCOUNT_OPEN_DATE))

2).TRUNC(MONTHS_BETWEEN(STG_TD_CONTRACTS.FIC_MIS_DATE,STG_TD_CONTRACTS.D_VALUE_DATE))

3).TRUNC(MONTHS_BETWEEN(STG_OD_ACCOUNTS.FIC_MIS_DATE,STG_OD_ACCOUNTS.D_VALUE_DATE))

4).TRUNC(MONTHS_BETWEEN(STG_MM_CONTRACTS.FIC_MIS_DATE,STG_MM_CONTRACTS.D_VALUE_DATE))

5).TRUNC(MONTHS_BETWEEN(STG_LOAN_CONTRACTS.FIC_MIS_DATE,STG_LOAN_CONTRACTS.D_VALUE_DATE))

6).TRUNC(MONTHS_BETWEEN(STG_INVESTMENTS.FIC_MIS_DATE,STG_INVESTMENTS.D_VALUE_DATE))

7).TRUNC(MONTHS_BETWEEN(STG_GUARANTEES.FIC_MIS_DATE,STG_GUARANTEES.D_VALUE_DATE))

8).TRUNC(MONTHS_BETWEEN(STG_BORROWINGS.FIC_MIS_DATE,STG_BORROWINGS.D_VALUE_DATE))

9).TRUNC(MONTHS_BETWEEN(STG_BILLS_CONTRACTS.FIC_MIS_DATE,STG_BILLS_CONTRACTS.D_VALUE_DATE))

10).TRUNC(MONTHS_BETWEEN(STG_MUTUAL_FUNDS.FIC_MIS_DATE,STG_MUTUAL_FUNDS.D_OPEN_DATE))

11).TRUNC(MONTHS_BETWEEN(STG_LEASES_CONTRACTS.FIC_MIS_DATE,STG_LEASES_CONTRACTS.D_LEASE_START_DATE))

12).TRUNC(MONTHS_BETWEEN(STG_LC_CONTRACTS.FIC_MIS_DATE,STG_LC_CONTRACTS.D_START_DATE))

13).TRUNC(MONTHS_BETWEEN(STG_COMMITMENT_CONTRACTS.FIC_MIS_DATE,STG_COMMITMENT_CONTRACTS.D_START_DATE))

14).TRUNC(MONTHS_BETWEEN(STG_CASA.FIC_MIS_DATE,STG_CASA.D_ACCT_OPEN_DATE))

15).TRUNC(MONTHS_BETWEEN(STG_ANNUITY_CONTRACTS.FIC_MIS_DATE,STG_ANNUITY_CONTRACTS.D_EFFECTIVE_DATE))



Changes

 NA

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
Changes
Cause
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.