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 laterInformation 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 |