My Oracle Support Banner

FFIEC009 consolidated Issues (Doc ID 2738862.1)

Last updated on DECEMBER 28, 2020

Applies to:

Oracle Financial Services - Regulatory Reporting for US Federal Reserve - Lombard Risk Integration Pack - Version 8.0.9 and later
Information in this document applies to any platform.

Symptoms

 FFIEC009 consolidated issues

Version: RRS 80961, FSDF 80930

1.
Records are getting rejected from FCT_REG_FUND_LEND_DETAILS and are being populated to the $ table due to "ORA-02291: integrity constraint (EONE.FK_3681_16) violated - parent key not found. This is because the entry of "MSG/OTH" record in DIM_CREDIT_LINE_STATUS is missing

2.
N_CUSTOMER_PARTY_SKEY is directly mapped from FCAS.N_CUSTOMER_SKEY, which is populated from DIM_CUSTOMER. However, the foreign key on FCT_REG_FUND_LEND_DETAILS .N_CUSTOMER_PARTY_SKEY is pointing to DIM_PARTY. N_PARTY_SKEY. Because of this, the records are getting rejected in the fact load process.

3.
There are certain party types being used in the filter conditions (AR-config package) but not available in the corresponding dimension table
'BCEAO', 'BEAC', 'BIS', 'ECCB'

Changes

 NA

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
Changes
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.