Home » Developer & Programmer » Forms » Unable to Insert record In forms: error -ORA-01779 :cannot modify a column (Oracle Apps)
Unable to Insert record In forms: error -ORA-01779 :cannot modify a column [message #393966] Wed, 25 March 2009 04:06 Go to next message
subirdutta
Messages: 7
Registered: September 2008
Location: Pune
Junior Member

Hi,
I have created one form with two block.
Block-1 : Based on View
Block-2 : Based on table

There is is relationship between Block-1 and Block-2.
Block-1 is populating from LOV.
I just need to insert /update record Block-2 based on data from Block-1
So Block-1 I have made read only at runtime (Inser/update all properties are false).

Now when I insert record in Block-2 based on record from block-1, and getting below error.
"ORA-01779: cannot modify a column which maps to a non key-preserved table"

It is not allowing to insert record.

Please help me.

Subir
  • Attachment: Error.JPG
    (Size: 69.18KB, Downloaded 93 times)
Re: Unable to Insert record In forms: error -ORA-01779 :cannot modify a column [message #394002 is a reply to message #393966] Wed, 25 March 2009 05:35 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
You've got some code that's modifying block one.

You can only get that error from trying to do DML on views.

When you say you're populating block1 from an LOV what exactly do you mean?
Re: Unable to Insert record In forms: error -ORA-01779 :cannot modify a column [message #394010 is a reply to message #394002] Wed, 25 March 2009 06:08 Go to previous messageGo to next message
subirdutta
Messages: 7
Registered: September 2008
Location: Pune
Junior Member

Just like master detail relation.
From LOV populating one record in the 1st block, the based on that record inserting record on 2nd block.
Re: Unable to Insert record In forms: error -ORA-01779 :cannot modify a column [message #394015 is a reply to message #393966] Wed, 25 March 2009 06:23 Go to previous message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
That really doesn't answer my question.

Are you using forms default query behaviour or are you manually populating the block from a cursor/procedure or something else?
Previous Topic: Disabling a button
Next Topic: How to assign a value to text item in particular format.
Goto Forum:
  


Current Time: Sat Dec 10 20:53:26 CST 2016

Total time taken to generate the page: 0.23103 seconds