A page in Oracle Apex can access data entered on another page if that data has been saved in session state or an APEX collection or if it has been committed to a database table.
There are two methods to pass items between two pages.
One way to pass data is to submit the page and then use a branch to redirect to the next page. This enables validations and processing to be applied. Data can be passed to the next page through collections, tables or by explicitly setting session state items in the next page.
The second way of passing is to call a page process using ajax or use an Execute PL/SQL dynamic action. Here the process is performed through a Execute PL/SQL dynamic action (or an ajax call back process) and a dynamic action is used on the button that opens the dialog that first calls the server side processing.
DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250-customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.