Update Reporting Rules Pkg (P_CFG_REG_REPORT_RULES_U) fails with ORA-02291: integrity constraint error (Doc ID 2196427.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Argus Safety Cloud Service - Version 8.0 to 8.0 [Release 8.0]
Information in this document applies to any platform.

Symptoms


Update Reporting Rules pkg (P_CFG_REG_REPORT_RULES_U) is not working

Attempting to update the reporting rules from back end using reporting rules pkg (P_CFG_REG_REPORT_RULES_U) or trying to generate audit log results in the following error:

Error:
-------

Error starting at line 1 in command:
exec PKG_CONSOLE_UPDATE_AUDIT.P_CFG_REG_REPORT_RULES_U('PROTECT',1,100191,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null);
Error report:
ORA-02291: integrity constraint (ARGUS_APP.FK_CRRR_LDRC_CATEGORY_ID) violated - parent key not found
ORA-06512: at "ARGUS_APP.PKG_CONSOLE_REPORTING_RULE", line 549
ORA-06512: at "ARGUS_APP.PKG_CONSOLE_UPDATE_AUDIT", line 5789
ORA-06512: at line 1
02291, 00000 - "integrity constraint (%s, %s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value
*Action: Delete the foreign key or add a matching primary key

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