DGS VA- OBIEE Enhancement - Account Level 2 ( Drill Down) Report
(Doc ID 2815697.1)
Last updated on OCTOBER 25, 2021
Applies to:Oracle Financial Services Data Governance for North America Regulatory Reporting - Version 8.0.8 and later
Information in this document applies to any platform.
DGS VA - OBIEE Enhancement - Account Drill down ( Level 2 Report)
Customer Requested to Add additional columns in Variance Analysis - Account drill down(Level 2)
1) "Days to Maturity" --> This will provide number of days left for the instrument to maturity
population logic = Maturity Date - Current Period Date (MISDATE).
E.g. Current Period - 31-DEC-2020
Instrument ID Maturity Date No of Days
ACCT1 31-Mar-2021 90 <>
ACCT2 30-Sep-2021 273 <>
ACCT3 31-Dec-2021 365 <>
2) "N_Origination_Date_Skey" and "Origination Date" from FCT_COMMON_ACCOUNT_SUMMARY
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