'ORA-02291: Integrity Constraint Violated' on N_DAY_COUNT_IND for Database Extract with FSDF 7.4 Installed (Doc ID 1625109.1)

Last updated on FEBRUARY 20, 2014

Applies to:

Oracle Financial Services Data Foundation - Version 7.4.0 and later
Oracle Financial Services Asset Liability Management Analytics - Version 6.1 and later
Oracle Financial Services Enterprise Financial Performance Analytics - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In an environment with Oracle Financial Services Asset Liability Analytics (ALMBI) 6.1 and/or Enterprise Financial Performance Analytics (PFTBI) 6.1 installed with the Financial Services Data Foundation (FSDF) 7.4, you get an error on the foreign key constraint between FCT_COMMON_ACCOUNT_SUMMARY and DIM_DAY_COUNT on the column N_DAY_COUNT_IND.

ORA-02291: integrity constraint (<atomic>.FK_T_COMMON_ACCOUNT_SUMMARY_13) violated - parent key not found

In the ALMBI and PFTBI T2T Database Extract definitions, the column ACCRUAL_BASIS_CD is mapped to the N_DAY_COUNT_IND column.  See example below:

            <MAP>
                <SOURCE TABLENAME="FSI_D_MORTGAGES" TYPE="FIELD">
                    <COLUMN FIELDORDER="87" ID="ACCRUAL_BASIS_CD">
                        <LENGTH/>
                        <DATATYPE>Number</DATATYPE>
                        <PRECISION/>
                        <SCALE/>
                        <NULLIF/>
                        <DEFAULTIF/>
                        <STARTPOSITION/>
                        <EXPRESSION/>
                    </COLUMN>
                </SOURCE>
                <DESTINATION>
                    <COLUMN ID="n_day_count_ind">
                        <LENGTH>5</LENGTH>
                        <DATATYPE>Number</DATATYPE>
                        <PRECISION/>
                        <SCALE/>
                        <ORDINAL>47</ORDINAL>
                        <SQLEXPRESSION/>
                        <NULLIF/>
                        <DEFAULTIF/>
                        <IDENTITYINCREMENT/>
                    </COLUMN>
                </DESTINATION>
            </MAP>

The Accrual Basis Code values do not match values in the DIM_DAY_COUNT table.  As a result, a foreign key constraint error occurs when trying to load data into FCT_COMMON_ACCOUNT_SUMMARY using the seeded T2T Extracts.  You do not understand why this foreign key constraint exists on the FCT_COMMON_ACCOUNT_SUMMARY table in the FSDF 7.4 data model.

Cause

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