Recently we have upgraded our Oracle Forms/DB from 10g to 11g. After this upgrade, users are reporting FRM-40602 in a Inquiry screen which is using a DB view to retrieve records from 2 base tables. View doesn't support INSERT/UPDATE/DELETE. Please help me to understand why "FRM-40602 - Unable to insert or update view" is occuring after the upgrade?
Additional information
Form Block properties
Query Data Source Name - DB view
Enforce Primary Key - No
Insert/Update/delete Allowed - Yes
Locking Mode - Automatic
Key Mode - Automatic