"ORA-02291: integrity constraint" When Clearing a Custom Picklist Field
Last updated on JULY 09, 2014
Applies to:Oracle Transportation Management - Version: 6.1.0 to 6.2.2 - Release: 6.1 to 6.2
Information in this document applies to any platform.
A custom Manager Layout is created where a field is updated to define a picklist of options.
This Manager Layout is used and a specific data is assigned to this configured field based on one of the pre-defined items from the picklist. When the object is updated again and this field is updated to select the "Null" option, the following error is observed:
Cannot update the <OBJECT> record. <Field Name> must reference a valid <Field Name> record.
java.sql.BatchUpdateException: ORA-02291: integrity constraint (GLOGOWNER.FK_) violated - parent key not found
This is because the SQL is trying to update the field with a value that does not use the domain. Howeverver, it shouldn't even be using that data at all. It should be updating to NULL as they selected the "empty" selection.
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