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!

Select List does not pass the selected value from the Master to the Detail (Session state) in a Inte

TinkerBoyNov 25 2019 — edited Mar 5 2020

Hi all. I created an app where you set-up the configuration of all the components that a PC needs (RAM, CPU Hard Disk etc). It is made up of Master Detail regions using Interactive Grids.

I found that if I use a Select List the Master Region will not pass the selected ID to the Detail Region in session state (Server Side). It does it on the client side but not in session state it seems. I build a little sample app to show what I mean.

https://apex.oracle.com/pls/apex/f?p=156025:6

workspace : JDPTest

user: DEV

pwd : qwerty12345

It has 2 regions.

  1. Master where you add a new record by selecting the data from a list.

pastedImage_1.png

pastedImage_2.png

  1. You add an employee by entering the code. It pulls down the Department as it is linked as a master detail column

Here you can see it does show the correct Department in the Display Field.

pastedImage_3.png

But when I try to save it you will see the detail department value is null. I did Debug the code and could see all other values are fine but not where some sort of LOV is used.

pastedImage_4.png

How do I make a Master Detail using some sort of selection in the Master region ?

Regards.

Comments
Post Details
Added on Nov 25 2019
11 comments
916 views