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!

Interactive Report Subscription's management

Pericles2 hours ago

Hello,

As an APEX application developer and instance administrator, I sometime encounter requests to modify Interactive Report (IR) Subscriptions—particularly those created by users who have since left the organization.

Currently, my workaround is to delete the underlying Saved Report, recreate it, and then set up a new subscription from scratch.

I am looking for documentation or best practices regarding the following:

  • Administrative Interface: Is there a way to edit existing subscriptions (Subject line, recipient list, or frequency) directly through the Workspace or Instance Administration galleries?
  • Database Level Updates: Are there supported APIs or specific metadata tables where these records can be safely updated via SQL?

Any insights or links to technical documentation on the internal mechanics of IR subscriptions would be greatly appreciated.

Thanks!

Comments
Post Details
Added 2 hours ago
0 comments
7 views