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:

Goal

DGS 80933 - VA - OBIEE Acct Drill down Reports

Problem Statement
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


Reason :
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.
 

Solution

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