OraFAQ Forum: Forms » Duplicate Record entry in the FORM BLOCK.

Home » Developer & Programmer » Forms » Duplicate Record entry in the FORM BLOCK.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Duplicate Record entry in the FORM BLOCK. [message #348784]

Wed, 17 September 2008 23:32

dev88
Messages: 15
Registered: September 2008
Location: SAN JOSE

Junior Member

Hi Gurus,

Please share you experience, if you come across a requirement below.

** I am developing a form where, have master detail relationship exists.
In the detail level a unique field combination should exists(Rules).

Rules:
Ex: Contract#| Item_name |Country | Begin_Date | End_Date
-------------------------------------------------------
(1) 123 | PHONE | US | 01-JAN-2008 | 01-JAN-2010
(2) 124 | CABLE | US | 01-JAN-2008 | 16-SEP-2008
(3) 124 | CABLE | US | 16-SEP-2008 | 16-OCT-2008

Up to this point it is working fine and good since i have defined unique index on (Item_id,Item_name,Country) at table level. So system is not allowing me to enter duplicate record.

Business requirement is : Entile record shold be non-updatable when, End_Date is less then sysdate.

Upto here it is fine and working good.

Here starts the issue, In a Scenario, if user want to define a new set of record with same combination thro
Begin and End Dates are different(as Line 3), system is not allowing to create a record since unique index exists. Since Line(2) of combination exists already.

Please let me know how to handle this situation.

Thanks,
DD.

[Updated on: Wed, 17 September 2008 23:36]

Report message to a moderator