My Oracle Support Banner

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.

Goal

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
 

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


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