1 person found this helpful
I need to reset the request value on a submit, as it seems to get lost on a save of the form. I am passing it in via a link setting on a previous page, and the request value drives the visibility of various parts of the form.
As I am saving in the form, the request value is obviously being reset and then sections of the page dissapear.
I am therefore trying to set the request value manually during the page process, but am getting an error.
When running this PL/SQL process.
TR_FOLLOW_UP = :P6_TR_FOLLOW_UP,
TR_COMMENTS = :P6_TR_COMMENTS,
TR_LAST_SAVED_BY = :APP_USER,
TR_LAST_SAVED_DATE = sysdate,
TR_XEVMPD_IMPACT = :P6_TR_XEVMPD_IMPACT,
TR_XEVMPD_COMMENT = :P6_TR_XEVMPD_COMMENT
WHERE CUSTOM_UNIQUE_ID = :P6_CUSTOM_UNIQUE_ID;
APEX_UTIL.set_session_state(p_name => 'REQUEST', p_value => 'SaveTriage');
It is not possible to set the REQUEST value programmatically. This can only be done in a button submit action, link, or branch.
For the use case described it looks like you will need to capture the REQUEST value on entry into a hidden page item, and use this to set the REQUEST when branching back to the page after submission.
Thanks, as always.