My Oracle Support Banner

VW_STG_PARTY_MASTER_CUST for Fn_STGDimDataLoader is Missing Fic_mis_date Filter (Doc ID 2562414.1)

Last updated on OCTOBER 14, 2019

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Oracle Financial Services Profitability Management - Version 8.0.7 and later
Oracle Financial Services Data Foundation - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Data Foundation (FSDF)
Oracle Financial Services Enterprise Performance Management (EPM)

Goal

Currently facing errors while running the Data Transformation (DT) - fn_STGDimDataLoader to load the intermediate customer Dimension table (DIM_CUSTOMER_B), from the master tables STG_PARTY_MASTER and STG_PARTY_ROLE_MAP. The out of the box view provided for this (VW_STG_PARTY_MASTER_CUST) - with configuration as n_dimension_id = 709 in 'FSI_DIM_ATTRIBUTE_MAP' has no limiting condition on fic_mis_date, due to which the error " Error. Staging Code column VW_STG_PARTY_MASTER_CUST.V_PARTY_ID should have Unique values' is getting logged in the fsi_message_log table and the dim data loader fails.

Since the Stg party master tables will always hold the history information sourced from master data system for various fic_miis_dates, the V_PARTY_IDs are bound to come multiple times under different fic_mis_dates over a period of time due to the slowly changing other attributes of the party info.

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


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