Hi all,
I have a Classic Report from which I pass a unique ID (USER_ROLE_ID) to a PL/SQL procedure. This is working well after I followed the ideas from the 2 excellent links at the bottom of this post.
Basically I have:
1. Created a URL Link column on the Classic Report
2. Stored the current row value in a Page Item with:
javascript:$s('P100_USER_ROLE_ID', '#USER_ROLE_ID#');
3. Created a Dynamic Action OnChange of the Page Item P100_USER_ROLE_ID
4. Call PL/SQL with :P100_USER_ROLE_ID as parameter and do a PPR to Refresh Page and show the result
This was working fine in the standard "Application Express Accounts" Authentication scheme, but it is no longer working in my custom scheme based on sentry. The custom scheme gets the current logged in SSO user and then sets this user with apex_custom_auth.set_user.
The issue is that although I can see Page Item P100_USER_ROLE_ID has the correct value, this value does no longer gets passed to the PL/SQL procedure. Instead it is NULL.
Is this perhaps a server setting? Can we somehow work around it from APEX side?
Appreciate your time!
Jeroen
-- https://community.oracle.com/tech/developers/discussion/3636203/select-row-from-classic-report-to-pass-value-to-another-classic-report-on-the-same-page
-- https://oraclefrontovik.com/2021/04/03/oracle-apex-passing-a-value-from-a-report-to-a-database-procedure/