Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Custom Form - APP-FND-01206: This Record Already Exists.

951614Aug 27 2014 — edited Sep 2 2014

Hi

We are getting the below error when trying to creating a record in a custom form. This error atleast was not occuring until 3 days back.

APP-FND-01206: This Record Already Exists. You Entered a Duplicate Value Or Sequence of Values That Must Be Unique for Every Record.

Tables and Forms Design

------------------------------------

4 tables --> a,b,c,d

a has a primary key and is the Header tab of the form (Header which is a single record )

b has a foreign key to a and is LinesĀ  tab of form (Lines tab --> Multi lines in a block tab)

c has a foreign key to a and is "Packing" tab of form (Packing tab- has a master c and detail d)

d is a child of c and is in the 3rd tab.

When we are creating a record , the above error is coming. Not sure what has changed.

Can you please provide right pointers to fix this issue ASAP

We followed the steps in the below URLs, it is not working though

https://community.oracle.com/thread/646366?tstart=0

https://community.oracle.com/thread/968894?start=0&tstart=0

Regards

This post has been answered by CraigB on Aug 28 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 30 2014
Added on Aug 27 2014
3 comments
1,448 views