Error:ORA-02291: integrity constraint (CONFIG.FK_PR2_RULE_OBJECT_MEMBER_1) violated - parent key not found (Doc ID 2299713.1)

Last updated on AUGUST 28, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.2 to 8.0.3 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When installing Oracle Financial Services Profitability Management (PFT) 8.0.2, when using a custom Infodom name, you get ORA-02291 errors like the one listed below in the OFS_PFT_installation.log for the script pr2_rule_object_member_801_ci.sql:

[Mon 14/8/2017 02:24:35] [OFS_PFT] [ INFO] - Executing file:/ofinst/ofsaa/scripts/config/insert/pr2_rule_object_member_801_ci.sql
[Mon 14/8/2017 02:24:35] [OFS_PFT] [ERROR] - Query:'MERGE INTO PR2_RULE_OBJECT_MEMBER T
USING (
SELECT '1431455799414' V_RULE_ID,'OFSPFTINFO' V_INFODOM_NAME,'HEPMDELQ' V_OBJECT_UNIQUE_NAME,'S' V_OBJECT_LOCATION_CODE,'[HEPMDELQ]' V_MEMBER_UNIQUE_NAME,'ND' V_MEMBER_TYPE_CODE,'1' N_MEMBER_ORDER,'N' F_DEFAULT_FLAG FROM DUAL
) S
ON (T.V_RULE_ID = S.V_RULE_ID AND T.V_INFODOM_NAME = S.V_INFODOM_NAME AND T.V_OBJECT_UNIQUE_NAME = S.V_OBJECT_UNIQUE_NAME AND T.V_OBJECT_LOCATION_CODE = S.V_OBJECT_LOCATION_CODE AND T.V_MEMBER_UNIQUE_NAME = S.V_MEMBER_UNIQUE_NAME)
WHEN MATCHED THEN
UPDATE
SET T.V_MEMBER_TYPE_CODE = S.V_MEMBER_TYPE_CODE,
T.N_MEMBER_ORDER = S.N_MEMBER_ORDER,
T.F_DEFAULT_FLAG = S.F_DEFAULT_FLAG
WHEN NOT MATCHED THEN
INSERT
(V_RULE_ID,V_INFODOM_NAME,V_OBJECT_UNIQUE_NAME,V_OBJECT_LOCATION_CODE,V_MEMBER_UNIQUE_NAME,V_MEMBER_TYPE_CODE,N_MEMBER_ORDER,F_DEFAULT_FLAG)
VALUES
(S.V_RULE_ID,S.V_INFODOM_NAME,S.V_OBJECT_UNIQUE_NAME,S.V_OBJECT_LOCATION_CODE,S.V_MEMBER_UNIQUE_NAME,S.V_MEMBER_TYPE_CODE,S.N_MEMBER_ORDER,S.F_DEFAULT_FLAG )'
Error:ORA-02291: integrity constraint (OFSAACONF.FK_PR2_RULE_OBJECT_MEMBER_1) violated - parent key not found

This error is repeated multiple times in the log.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms