My Oracle Support Banner

DGS VA - Enhancement - New VA Report With LOB And SOR Prompt (Doc ID 2810280.1)

Last updated on OCTOBER 04, 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 - New OBIEE Report as Enhancement
Customer is looking for a new Report which provides them to filter on SOR/LOB line as well

Current Summary Report -
This report do not have SOR and LOB Filter as RRS batches are run only on LE

New Ask
AS SOR/LOB filter can not be added in DGS VA Summary Report Prompt , Customer has asked for a new Report to be created
1) Which will have all Prompts similar to DGS VA Summary Page and ad two more prompts ( LOB and SOR)
2) Report should show data from FCT_XXX_ACCOUNT Table
3) These Report should show Total MDRM Balances similar to Summary Reports but from Account Tables

OOB Reports has "Data Origin Reports" where SOR is already added as Column ( where user can drag and drop)
 

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.