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 laterOracle Forms for OCI - Version 12.2.1.4.0 and later
Information in this document applies to any platform.
Symptoms
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
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |