ORA-02298: cannot validate (OPA.OPA_SETTINGS_KEYS_FK) - parent keys not found (Doc ID 849330.1)

Last updated on NOVEMBER 14, 2016

Applies to:

Adverse Event Reporting System - Version 4.6.0 and later
Information in this document applies to any platform.
***Checked for relevance on 07-DEC-2010***
***Checked for relevance on 10-MAY-2012***
***Checked for relevance on 10-JAN-2014***
***Checked for relevance on 11-JUN-2014***

Symptoms

AERS 4.6 Database Install review of the log file shows warning:

Alter table opa_settings enable constraint opa_settings_keys_fk
*
ERROR at line 1:
ORA-02298: cannot validate (OPA.OPA_SETTINGS_KEYS_FK) - parent keys not found

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