Skip to Main Content

APEX

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!

APEX 5 - Interactive Grid used on a VIEW

Bernhard FWAug 29 2017 — edited Sep 28 2017

I like to use IG on a view, which I created on 2 tables (Master/Detail or Order/Order-Details)... with cascade constraints on FK of the Detail Table.

But having changed a column and like to save - the IG is throwing flwg. error saying :

"Ajax call returned server error ORA-20987: APEX - nothing done - ORA-01779: cannot modify a column which maps to a non key-preserved table for ."

What sort of View do I have to use ? Any workaround ? What to consider ?

TIA

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2017
Added on Aug 29 2017
4 comments
1,082 views