My Oracle Support Banner

After Upgrading ALM To 8.1.2.2, ORA-02291 Errors Found In OFS_ALM_installation.log At Insert Into FSI_M_LOOKUP_B (Doc ID 2953802.1)

Last updated on JUNE 14, 2023

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.1.2.2 and later
Oracle Financial Services Asset Liability Management - Version 8.1.2.2 and later
Information in this document applies to any platform.
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Modern Risk and Finance (MRF)

Symptoms

Post upgrading ALM to 8.1.2.2.0, you noticed below INSERT errors in the OFS_ALM_installation.log.

 

ERRORS

[05-04-23 12:32:08,829 AST PM] [INFO ] Executing file :/u01/app/ofsaa/installerScripts/OFS_ALM/scripts/atomic/insert/ftp8122_tp_ibor_atm.sql
[05-04-23 12:32:09,005 AST PM] [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>.FK_FSI_M_LOOKUP_B_1) violated - parent key not found

[05-04-23 12:32:09,012 AST PM] [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>.FK_FSI_M_LOOKUP_B_1) violated - parent key not found

[05-04-23 12:32:09,017 AST PM] [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>.FK_FSI_M_LOOKUP_B_1) violated - parent key not found

[05-04-23 12:32:09,022 AST PM] [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>.FK_FSI_M_LOOKUP_B_1) violated - parent key not found

[05-04-23 12:32:09,027 AST PM] [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>.FK_FSI_M_LOOKUP_B_1) violated - parent key not found

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.