My Oracle Support Banner

ORA-02291: integrity constraint parent key not found Errors Observed in Logs When Applying 8.0.x Patch (Doc ID 2723745.1)

Last updated on APRIL 21, 2021

Applies to:

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

Goal

In the installation logs when applying 8074 PFT ML Patch, ORA-02291: integrity constraint parent key not found errors are received while running:
-batch_task_master_pftbi.sql
-batch_parameter_master_pftbi.sql
-management_ledger_task3.sql
-fn_refresh_pa_param_change.sql

Issue has been resolved with similar workarounds found before (for example: Doc ID 2299713.1 Error:ORA-02291: integrity constraint (CONFIG.FK_PR2_RULE_OBJECT_MEMBER_1) violated - parent key not found) as scripts contain the wrong Infodom setting.

Hence issue has been solved after rerunning the errored scripts manually, by replacing below place holders:
1) ##INFODOM##
2) ##REVUSER##
3) ##IP Address##

Is there going to be a permanent fix for this issue?

Solution

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