FRM-40508 / ORA-00001 Or ORA-02291 When Committing Form (Doc ID 1033943.6)

Last updated on MAY 31, 2023

Applies to:

Oracle Forms - Version 6.0.8 and later
Oracle Forms for OCI - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Your form contains a main-detail relationship.
You insert records into the main block and into the detail block.

Oracle Forms then prompts you to save changes.
When you click on the Yes button to commit the form, one of the following error combinations occur:

Combination 1
-------------
FRM-40508: ORACLE error: unable to INSERT record.

When you select the Help-->Display Error menu option, the following error appears:

ORA-00001: unique constraint <table.column> violated

Combination 2
-------------
ORA-02291: integrity constraint <str.name> violated - parent key not found

	To view full details, 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 a vibrant support community of peers and Oracle experts.