How Does the DIM_ACCOUNT SCD Work for Multi GAAP Code (USGAAP, BEGAAP Etc..)?
(Doc ID 2385814.1)
Last updated on MARCH 24, 2023
Applies to:
Oracle Financial Services Asset Liability Management - Version 8.0.0 to 8.0.7 [Release 8]Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics - Version 8.0.0 to 8.0.7 [Release 8]
Oracle Financial Services Data Foundation - Version 8.0.0 to 8.0.7 [Release 8]
Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.0 to 8.0.7 [Release 8]
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
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 |