How Does the DIM_ACCOUNT SCD Work for Multi GAAP Code (USGAAP, BEGAAP Etc..)?

(Doc ID 2385814.1)

Last updated on JULY 03, 2018

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management Analytics - Version 8.0.0 and later
Oracle Financial Services Data Foundation - Version 8.0.0 and later
Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.0 and later
Information in this document applies to any platform.
OFS ALM - Oracle Financial Services Asset Liability Management
Oracle Business Intelligence Enterprise Edition (OBIEE)
Oracle Financial Services Asset Liability Management Analytics (ALMBI)
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI) previously known as Oracle Financial Services Profitability Analytics
Reporting

Goal

How does the DIM_ACCOUNT Slowly Changing Dimension (SCD) work for multi GAAP Code (USGAAP, BEGAAP etc..)?

For source table, each view has a specific Filter condition for default gaap code. While implementing Group levels there are multiple GAAP codes like for UK there is USGAAP and For Belgium data there is BEGAAP.

However, as per the current DIM_ACCOUNT SCD setup it seems to be working for only one GAAP because of below view condition:

AND nvl(t.V_GAAP_CODE,(SELECT V_COMPONENT_VALUE FROM SETUP_MASTER WHERE V_COMPONENT_DESC = 'DEFAULT_GAAP')) = (SELECT V_COMPONENT_VALUE FROM SETUP_MASTER WHERE V_COMPONENT_DESC = 'DEFAULT_GAAP' );

What is the solution for Populating DIM_ACCOUNT by SCD for multiple GAAP Code? If entering two default Gaap code in setup master it will fail because will return two values.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms