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!

master detail IG with detail region primary key as LOV sets session state with just one value and do

user12882023May 27 2019 — edited May 28 2019

I am implementing a Interactive grid to perform DML operations on a table.

it has combined primary key of two columns One primary key column is display only and refer to master table and another primary key column I want to have a LOV to select value. LOV is dynamic lov having a display and return value picked from another table.

Inserts are fine but session state item value is set for one row and all the operations are performed on that same row irrespective of which row is selected.

you can see a sample here https://apex.oracle.com/pls/apex/f?p=128616:2:1964277347439::NO:::

master table name: sample detail table name: sample_child

primary key in sample child : ID and Name pop lov is implemented in NAME LOV values are picked from table: Sample_uncle LOV display : ID || '-' || NAME LOV return : ID

you can try to update blabla column of sample_child table to see the issue.

I am not sure how I can give you access to look at the implementation.

I have already tried all the options I can think of

Comments
Post Details
Added on May 27 2019
1 comment
562 views