My Oracle Support Banner

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 MARCH 25, 2019

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


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 ?


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

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