Oracle 11gex
Apex 5.02
Glassfish 4
I've got a tabular form based on a SQL Query (updateable report), and have multiple columns of that report set up with defaults using the (Tabular Form Attributes: Default Type and Default [value] ).
I am able to save values for text fields and check boxes during the automatic MRU process, but I am having trouble with two hidden date fields and a hidden number field. The date columns (Column Attributes: display as = 'Date Picker') but are hidden(saves state); and their value is being set using Type: PLSQL Expression Default=sysdate. The number field has it's Column Attributes: display as = 'hidden(saves state)' and I am trying to use an Application Item to set this default value... so Tabular Form Attributes: Default type = Item, Default = P0_AGENTID (global page 0 application item). The application item P0_AGENTID does have a value in session state before and during the page processes.
I believe these settings should work, so there must be something else about the page that is stepping on the process.
I would appreciate any suggestions on how to diagnose the problem, or direction on how to do this the 'right' way.
Thanks