Running Oracle Apex version 21.2.3 on Oracle Database version 19c.
I have a checkbox group that has multiple items. Once I check/uncheck I store these in page items.
Then the user can press the “Next” button to proceed to the next page. But before going to the next page, I set some page items , including one used as a flag for validation, and do it as Execute Server-side PL/SQL Code TRUE actions under a Dynamic Action of the button Event → Click, Selection Type → Button Name → NEXT_BUTTON. Behavior → Submit.
I have 1 Set Value action, + 5 Exec PL/SQL code actions. These should and do all fire (as I have the page items visible when I press the button). The problem is, the Validation to determine whether or not I can go to the next page is based on a page item being set to a value (in my case “N” for no errors found). Since my test case does produce a YES, errors found, the validation should fail.
But it proceeds and goes to the next page. No ironically when I press the “Bac my app, not “back” button on my browser and THEN try to hit next, THEN the validation triggers failure and stops.
Any thoughts? Am I missing something in terms of the firing order of the validation?
Thanks,