Can the DT fn_popDimAccount Function be Used to Load Data Into DIM_ACCOUNT Table in 8.x?

(Doc ID 2345786.1)

Last updated on JANUARY 11, 2018

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
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

Currently using the DT fn_popDimAccount which invokes the OOTB Package /function : STG_POP_DIM_ACCOUNT.populateDimAccount, to populate the DIM_ACCOUNT table.
This function however does not consider the LOAD RUN ID concept and hence if the base table contains multiple LOADS for the same date (with the same set of ACCOUNTS), it populates multiple records in DIM_ACCOUNT.
How this should be handled ?

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