I have an Oracle Forms riddle for you. I'm in Oracle Forms 11g.
I have non-base-table item which I change the value of programatically in a post-query trigger. This should not cause the record status to change (since it's non-base-table), but it does! When I set the item's Validate-from-List property to 'Yes' and change the value, the record status changes and the user gets prompted to save upon exit when they have not made any changes. What's going on here and how do I get around this problem?