Could you show us the code you are using to update your underlying view table? Just off the top of my head, my guess is that there is an error during the update, but this is just a guess.
Also, it would be helpful to know your Forms version, how your application is deployed, are you using a standard Forms data block or a non-base table block and writing the DML in code versus letting Forms handle the DML. Please include any other information you feel might help us understand your situation and offer you possible solutions.
I update the value of the column like that :
update MY_TABLE set MY_COLUMN = 'value' where <condition>;
Strange think is that :
- select my_column into my_variable from my_table where <condition> ==> value updated
- :MY_BLOCK.MY_COLUMN ==> value not updated (MY_BLOCK is based on a view based on my table).
Forms version : 10.1.2.0.2