My Oracle Support Banner

FTP Upgrade to 8.1.2.2 Getting 'ORA-02291: integrity constraint (<ATOMIC>.FK_FSI_M_LOOKUP_B_1) violated - parent key not found' (Doc ID 2992836.1)

Last updated on JANUARY 12, 2024

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.1.2.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)

Symptoms

When upgrading FTP from 8.1.2 to 8.1.2.2, you get "parent key not found" errors in the install log.

The following exists in the OFS_FTP_installation.log:

[20-03-23 10:36:59,028 CDT AM] [INFO ] Executing file :/<FIC_HOME>/installerScripts/OFS_FTP/scripts/atomic/insert/ftp8122_tp_ibor_atm.sql
[20-03-23 10:36:59,123 CDT AM] [ERROR] Query:MERGE INTO fsi_m_lookup_b TAB USING ( SELECT '1' LOOKUP_CD,'565920015' CATEGORY_ID FROM DUAL )PROXY ON(TAB.LOOKUP_CD = PROXY.LOOKUP_CD AND PROXY.CATEGORY_ID = TAB.CATEGORY_ID)...
Error:ORA-02291: integrity constraint (<ATOMIC USER>.FK_FSI_M_LOOKUP_B_1) violated - parent key not found


[20-03-23 10:36:59,130 CDT AM] [ERROR] Query:MERGE INTO fsi_m_lookup_b TAB USING ( SELECT '2' LOOKUP_CD,'565920015' CATEGORY_ID FROM DUAL )PROXY ON(TAB.LOOKUP_CD = PROXY.LOOKUP_CD AND PROXY.CATEGORY_ID = TAB.CATEGORY_ID)...
Error:ORA-02291: integrity constraint (<ATOMIC USER>.FK_FSI_M_LOOKUP_B_1) violated - parent key not found


[20-03-23 10:36:59,138 CDT AM] [ERROR] Query:MERGE INTO fsi_m_lookup_b TAB USING ( SELECT '3' LOOKUP_CD,'565920015' CATEGORY_ID FROM DUAL )PROXY ON(TAB.LOOKUP_CD = PROXY.LOOKUP_CD AND PROXY.CATEGORY_ID = TAB.CATEGORY_ID)...
Error:ORA-02291: integrity constraint (<ATOMIC USER>.FK_FSI_M_LOOKUP_B_1) violated - parent key not found


[20-03-23 10:36:59,142 CDT AM] [ERROR] Query:MERGE INTO fsi_m_lookup_b TAB USING ( SELECT '4' LOOKUP_CD,'565920015' CATEGORY_ID FROM DUAL )PROXY ON(TAB.LOOKUP_CD = PROXY.LOOKUP_CD AND PROXY.CATEGORY_ID = TAB.CATEGORY_ID)...
Error:ORA-02291: integrity constraint (<ATOMIC USER>.FK_FSI_M_LOOKUP_B_1) violated - parent key not found


[20-03-23 10:36:59,145 CDT AM] [ERROR] Query:MERGE INTO fsi_m_lookup_b TAB USING ( SELECT '5' LOOKUP_CD,'565920015' CATEGORY_ID FROM DUAL )PROXY ON(TAB.LOOKUP_CD = PROXY.LOOKUP_CD AND PROXY.CATEGORY_ID = TAB.CATEGORY_ID)...
Error:ORA-02291: integrity constraint (<ATOMIC USER>.FK_FSI_M_LOOKUP_B_1) violated - parent key not found



You are not sure of the impact of these errors on the FTP upgrade.

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.