DGS VA - OBIEE ACCT Drill Down Reports - N_REG_PROD_CLASSIFICATION_SKEY Usage In FRAS
(Doc ID 2824744.1)
Last updated on DECEMBER 05, 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 80933 - VA - OBIEE Acct Drill down Reports
the Reports uses N_REG_PROD_CLASSIFICATION_SKEY from FCT_LOAN_ACCOUNT_SUMMARY table considering all Loan Related accounts ae stored in this Table
However DGS ACCT Drill down Reports should use FCT_REG_ACCOUNT_SUMMARY.N_REG_PROD_CLASSIFICATION_SKEY
There are multiple loans which are not sourced to STG_LOAN_CONTRACTS like credit Card loans/Repo loans and so on.
hence they may not be able to flow to FCT_LOAN_ACCOUNT_SUMMARY hence FCT_REG_ACCOUNT_SUMMARY table should be used to make join
in ACCT Drill down Report.
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