I have an Oracle APEX application with a public page (no authentication) and the following URL:
https://oracleapex.com/ords/r/*****/*****/home
On this page, there is a page item named P1_NEW, which I want to populate using a value passed through the URL.
I created a button in Oracle Fusion that redirects to this APEX page. The goal is to pass a runtime value (for example, the current Fusion user’s User ID or Person ID) to the APEX page so it can be used to filter report data.
However, when the button is clicked, Fusion generates the following URL:
https://oracleapex.com/ords/r/*******/*******/home?P1_NEW=
The parameter is present, but its value is empty. This appears to happen because EL expressions such as #{UserId} are not supported in this context, so Fusion does not resolve the value when building the URL.
I understand that passing user identifiers via URL parameters is not secure and that federated authentication (SSO) is the recommended approach. However, this requirement is only for testing and learning purposes, not for a production or business use case.
My questions are:
- Is there any supported way in Oracle Fusion to pass a runtime value (such as User ID or Person ID) to an external URL when using a button or link?
- If not, is this a known limitation of Oracle Fusion URL/EL expression support that must be handled on the Fusion side?