Wow, this is really frustrating.
This is a variation of the problem I had on my modal dialog from yesterday, but it involves the Interactive Grid.
When I add a row in an IG, and I set the default value to :P2_ROW_MID (Metric ID) it does not load the current value.
As you can see, the confirmation dialog shows that the current MID =25 which corresponds to Test Plan. That value is currently in P2_ROW_MID and was saved to the session using PL/SQL as suggested in yesterday's thread.
Description automatically generated
Here you can see the third item passed is the P2_ROW_MID value and that is what shows up in the confirmation dialog above. So, I am pretty sure the correct value (25) is making it into the session.
Description automatically generated
I have now tried multiple approaches to getting this session value into the MID column. The first uses a direct reference to the P2_ROW_MID item, which has the correct value (25) Test Plan, yet the defaulted value is (109) Test shown above.
Description automatically generated with medium confidence
The second uses SQL to return the value. I have used this technique in other situations (e.g. unbound controls) and it seems to work for them, but not within the context of an IG column.
Description automatically generated
Description automatically generated
I have tried with and without “Duplicate Copies Existing Value” without any success.
The bottom line is that MID being set into the default is NOT the MID that is in the P2_ROW_MID or its session state value.
Ideas?