I'm working on a page where the value of several display only page items are set using a Dynamic Action. They are set when the user picks a value in a select list (and is based on the select list value). The dynamic action fires on a Change event for the select list and then executes true action "Set Value". The select list displays sales rep names. The three fields dynamically populated are the org structure (i.e., their management chain).
For the Set Value action I'm using a Set Type of SQL Statement:
select VP, DIR, MGR
from SALES_ORG where SSR = :P20_SSR
In Affected Elements I've set Selection Type to "Item(s)", and Item(s) value to "P20_GVP,P20_DIR,P20_MGR"
The dynamic action works correctly for page display (i.e., when I select a sales rep in the select list the dynamic action correctly updates the value the three display only fields). This page is also a form in which the user submits info relating to the rep. When the page is Submitted, all fields are populated in a new DB record except for the three that were dynamically populated above. Those fields get NULL values.
When the dynamic action updates the values of the three fields is it not setting the session value? Other ideas why those fields aren't being captured in the Submit > Page Process?
I'm using APEX 5 with Chrome on Mac (Yosemite).