Oracle Apex: Passing variables to pages - be aware of session state

Problem

You want to pass variables from one page to another, for example via a link attribute on a button.

In the above example datafix_id and datafix_file_id were sent through, but LT reference (which was typed into the form), was not.

The key difference is that the first 2 variables were already in session state, whereas the 3rd one was merely typed into the browser, it did not exist in session state.

Solution

Instead of using your button to redirect to the new page and pass the variables accross, you need to force the variables into session state and redirect to the page.

Change your button action from a link, to a dynamic action. Your actions are (1) to execute a dummy piece of code (and we use the opportunity to introduce that values into session state), and (2) to submit the page.

(1) Here is the dummy code.

Note how we submit the items. they are now in session state.

(2) 

Nothing special here, but you now need a redirect.

...and on the propertied you tell it where to go to and what variables you want to pass.

Acknowledgement

Thanks to Theo: https://www.linkedin.com/in/papadakistheo