ORA-28117: integrity constraint violated - parent record not found

Cause : try to update/insert a child record with new foreign key values, but the corresponding parent row is not visible because of fine-grained security in the parent.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

make sure that the updated foreign key values must also visible in the parent

update : 26-05-2017

ORA-28117 - integrity constraint violated - parent record not found
ORA-28117 - integrity constraint violated - parent record not found

  • ora-02757 : osnfop: fork_and_bind failed
  • ora-00271 : there are no logs that need archiving
  • ora-39111 : Dependent object type string skipped, base object type string already exists
  • ora-30991 : cannot use DOM to add special attribute to schema-based parent
  • ora-22601 : pickler TDS context [string] is not initialized
  • ora-15051 : file 'string' contains string error(s)
  • ora-24027 : AQ HTTP propagation encountered error, status-code string, string
  • ora-07416 : slpath: pathname construction failed; lack of output buffer space.
  • ora-07251 : spcre: semget error, could not allocate any semaphores.
  • ora-29553 : class in use: string.string
  • ora-29319 : datafile string is not correct
  • ora-01261 : Parameter string destination string cannot be translated
  • ora-32162 : Read/Write SQL method not registered
  • ora-01345 : must be a LogMiner coordinator process
  • ora-16607 : one or more databases have failed
  • ora-00478 : SMON process terminated due to error string
  • ora-04932 : increment or adjust of sequence number failed
  • ora-28344 : fails to decrypt data
  • ora-39061 : import mode string conflicts with export mode string
  • ora-29356 : These parameters can be specified only for directives that refer to consumer groups
  • ora-15105 : missing or invalid FAILGROUP name
  • ora-01715 : UNIQUE may not be used with a cluster index
  • ora-02402 : PLAN_TABLE not found
  • ora-01891 : Datetime/Interval internal error
  • ora-16822 : new primary database not yet ready for standby database reinstatement
  • ora-33313 : (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.
  • ora-01195 : online backup of file string needs more recovery to be consistent
  • ora-25448 : rule string.string has errors
  • ora-14005 : missing RANGE keyword
  • ora-04009 : MAXVALUE cannot be made to be less than the current value
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.