There seems to be a missing feature in a master detail interactive grid, that is when errors happen on the detail grid when another master record is active.
A simple way to reproduce on:
https://apex.oracle.com/pls/apex/r/rnd_myspace/a4357220220413113554788/stacked
Click the second master record
Change the Due Date of a milestone to a text value
Click the first master record
Click save
Now you get an error “Due Date does not match format DD-MON-RR” , but clicking this does not work. The reason is that it tries to go to the detail record with a certain ID, but that is not active now.
This is a real problem if you make multiple changes in the grids. There is no way to see where the errors are made.
The best solution would be that clicking the error also changed the current master record to the correct one.
An alternative would be that at least an indicator was visible on the master records that have errors in the details.
Anyone made a workaround for this?
@john-snyders-oracle