My Oracle Support Banner

FSDF SCD-132 DIM_LOB Dimension Has FIC_MIS_DATE Filter Auto Applied (Doc ID 2623999.1)

Last updated on AUGUST 21, 2020

Applies to:

Oracle Financial Services Data Foundation - Version 8.0.7 to 8.0.8 [Release 8]
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 to 8.0.8 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Data Foundation (FSDF)
Slowly Changing Dimension (SCD)


Symptoms

On 8.0.7 version, data loaded via SCD 132 into DIM_LOB has filter auto-applied on FIC_MIS_DATE

During load of data into DIM_LOB dimension via SCD 132 (as taken from map_ref_num table), it was noticed that FIC_MIS_DATE filter is getting applied on the source view (DIM_LOB_V) and the number of loaded records is limited.
As seen in the out-of-the-box (OOTB) MERGE query generated as part of the processing, SCD has filter in the WHERE clause for the batch run extraction date.

Cause

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
Symptoms
Cause
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.