We have a complex interactive grid, editable, most columns with Select Lists.
We pre-populated the rows based on some previous questions, then the user gets to the grid.
When there is One Row, upon SAVE all of the Select List values in the row are not registering ( they show NULL in the record, in the DEBUG info) even though on the screen they display as selected, and have the little indicator triangle that they have indeed been edited.
After SAVE, looking at the row in the database, I can see Row Version 2 - so the save did happen - and non-Select list values are set, but not the Select List values.
When there are 2 or more rows in the grid, all the values save EXCEPT for the first editable select list value. That one always fails validation ( and indeed behind the scenes, in the DEBUG info, shows as NULL), This column is a simple select list.
Sometimes I can reset the value and all is OK from there.
For some users, resetting the value never works. The row always fails validation - OR saves with a NULL value in that row when all validations are turned off.
Has anyone ever seen such behavior?
Anyone have any hints? things to try?
I am working on getting an example to apex.oracle.com.
Will update this with that info as soon as it is there.
In the meantime, anyone interested in seeing this weirdness and offering a suggestion, direct message me and I will walk you through it.
Thank you, Karen