Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX Interactive Report Subscription User Initialization PL/SQL Code

Jan-Peter MeyerApr 18 2025

Hi,
we use Interactive Report End User Subscriptions.
As these are individual to the User creating the subscription, I assume, that they being executed in an APEX session set to this User.
We use Oracle VPD based on a session context value which set in the APEX Application “Database Session” → “Initialization PL/SQL Code” section.
It seems, that this section is also executed, when the APEX Session is created for the execution of the subscription.
Before I rely on this, I am looking for confirmation (or contradiction) of this assumption.
Does anybody have any insight or maybe a even a pointer to related documentation?

Regards,
J.-P.

Comments
Post Details
Added on Apr 18 2025
0 comments
1,900 views