{"id":41024,"date":"2025-10-15T23:52:50","date_gmt":"2025-10-15T21:52:50","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=41024"},"modified":"2025-10-16T08:34:32","modified_gmt":"2025-10-16T06:34:32","slug":"ir-subscriptions-joelkallmanday","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/","title":{"rendered":"APEX IR Subscriptions #JoelKallmanDay"},"content":{"rendered":"\n

Interactive Reports allow to send their content per e-mail on a regular basis thanks to the subscription feature. But this can also raise some security concerns. Let’s see how to bring some kind of control into the game…<\/p>\n\n\n\n

Requirements<\/h2>\n\n\n\n

We developed some reporting solution for an Insurance company based on #orclAPEX. Some of the reports need to be sent on a regular basis, as Excel, to people like executive managers and that’s where Interactive Reports Subscription comes into the game.
As you can imagine, such reports may contain confidential data which should not be sent outside of the company (at least not by the reporting application itself).<\/p>\n\n\n\n

There are many ways to control the e-mail flows, but in some cases it takes time to implement changes in company global rules. So, let’s start with small changes until the bigger ones can be implemented…<\/p>\n\n\n\n

The need is to let the application Administrators see all IR subscriptions, identify the ones with a target e-mail address outside of the company and delete them.<\/p>\n\n\n\n

Implementation<\/h2>\n\n\n\n

Prior to use of subscription, e-mail server must be configured at APEX instance level.<\/p>\n\n\n\n

First we need to build the query of the report. To do so, let’s identify the APEX views which can provide the required information about the IR subscription within the APEX_DICTIONARY.
We are looking for information within the application, so view name will start by
APEX_APPLICATION_…
The reports are located in application pages, so view name will add as following APEX_APPLICATION_PAGE_…
Within the page we are looking for the Interactive Report
APEX_APPLICATION_PAGE_IR_…
And for the Interactive Report, Subscription definition is required: APEX_APPLICATION_PAGE_IR_SUB<\/strong><\/p>\n\n\n\n

The structure of the reports pages in scope is basic and contains only one Interactive Report. The name of the page is enough to identify the report in the list, so the APEX_APPLICATION_PAGES<\/strong> view needs to be joined.
There is only one workspace, so there is no need to identify the workspace, but only the application.
The query looks as following:<\/p>\n\n\n\n

SELECT ap.page_id,
ap.page_name,
apis.notify_id,
apis.owner,
apis.email_address,
apis.email_subject,
apis.start_date,
apis.notify_internal,
apis.end_date,
apis.download_format,
apis.created_on,
apis.status
FROM apex_application_pages ap, apex_application_page_ir_sub apis
WHERE ap.application_id = v('APP_ID')
AND ap.application_id = apis.application_id
AND ap.page_id = apis.page_id<\/code><\/p>\n\n\n\n

The best place to add the report in the application, is the standard administration reports provided by APEX and already in use:<\/p>\n\n\n\n

\"APEX

The report output is an Interactive Report in a Modal Dialog like the other Administration reports. We use field highlighting to identify e-mail addresses outside of company domain …
\"Report<\/p>\n\n\n\n

Let’s check for a blog within the community to see how to add the delete column:
https:\/\/vinish.dev\/create-delete-row-button-for-interactive-report-in-oracle-apex<\/a><\/p>\n\n\n\n

The deletion procedure is DELETE_SUBSCRIPTION<\/a> given by the APEX_IR<\/a> PL\/SQL API package. The required subscription_id<\/code> parameter is given by the notify_id<\/code> field in the apex_application_page_ir_sub<\/code> view.<\/p>\n\n\n\n

And the JavaScript Confirmation message looks like this:
\"Deletion
thanks to following parameters:
\"Deletion<\/p>\n\n\n\n

Conclusion<\/h2>\n\n\n\n

With some basic add-on, based on APEX views and PL\/SQL APIs it is easy to provide monitoring and control upon Interactive Report Subscriptions within an application.
I hope this helps you to start with such requirements…
… enjoy APEX development<\/p>\n","protected":false},"excerpt":{"rendered":"

Interactive Reports allow to send their content per e-mail on a regular basis thanks to the subscription feature. But this can also raise some security concerns. Let’s see how to bring some kind of control into the game… Requirements We developed some reporting solution for an Insurance company based on #orclAPEX. Some of the reports […]<\/p>\n","protected":false},"author":17,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[368,59],"tags":[304,3693,96,3616],"type_dbi":[3694],"class_list":["post-41024","post","type-post","status-publish","format-standard","hentry","category-development-performance","category-oracle","tag-apex","tag-joelkallmanday-2","tag-oracle","tag-orclapex-2","type-orclapex"],"acf":[],"yoast_head":"\nAPEX IR Subscriptions #JoelKallmanDay - dbi Blog<\/title>\n<meta name=\"description\" content=\"APEX Interactive Report Subscription allows to distribute reports via E-mail. Let's see how to bring some control into the game.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"APEX IR Subscriptions #JoelKallmanDay\" \/>\n<meta property=\"og:description\" content=\"APEX Interactive Report Subscription allows to distribute reports via E-mail. Let's see how to bring some control into the game.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-15T21:52:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-16T06:34:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/AdministrationReports.png\" \/>\n\t<meta property=\"og:image:width\" content=\"777\" \/>\n\t<meta property=\"og:image:height\" content=\"607\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Alain Lacour\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alain Lacour\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/\"},\"author\":{\"name\":\"Alain Lacour\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\"},\"headline\":\"APEX IR Subscriptions #JoelKallmanDay\",\"datePublished\":\"2025-10-15T21:52:50+00:00\",\"dateModified\":\"2025-10-16T06:34:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/\"},\"wordCount\":499,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/AdministrationReports.png\",\"keywords\":[\"APEX\",\"JoelKallmanDay\",\"Oracle\",\"orclapex\"],\"articleSection\":[\"Development & Performance\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/\",\"name\":\"APEX IR Subscriptions #JoelKallmanDay - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/AdministrationReports.png\",\"datePublished\":\"2025-10-15T21:52:50+00:00\",\"dateModified\":\"2025-10-16T06:34:32+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\"},\"description\":\"APEX Interactive Report Subscription allows to distribute reports via E-mail. Let's see how to bring some control into the game.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/AdministrationReports.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/AdministrationReports.png\",\"width\":777,\"height\":607},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"APEX IR Subscriptions #JoelKallmanDay\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\",\"name\":\"Alain Lacour\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"caption\":\"Alain Lacour\"},\"description\":\"Alain Lacour has more than 15 years of experience in application development with Oracle technologies. He is specialized in APEX, Java, and PL\/SQL development. His expertise also includes middleware technologies such as Oracle Weblogic and EMC Documentum. He also has a broad experience in business analysis and architecture solutions as well as in service and project management. Prior to dbi services, Alain Lacour was Senior Consultant at IMS Health in Basel. He also worked as a Software Engineer for M&H Informatics in Basel. Alain Lacour holds a Master of Science in Industrial Computing from the University of Mulhouse (F). His branch-related experience mainly covers the pharma industry, with an in-depth knowledge of the drug development process as well as drug distribution.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/alain-lacour\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"APEX IR Subscriptions #JoelKallmanDay - dbi Blog","description":"APEX Interactive Report Subscription allows to distribute reports via E-mail. Let's see how to bring some control into the game.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/","og_locale":"en_US","og_type":"article","og_title":"APEX IR Subscriptions #JoelKallmanDay","og_description":"APEX Interactive Report Subscription allows to distribute reports via E-mail. Let's see how to bring some control into the game.","og_url":"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/","og_site_name":"dbi Blog","article_published_time":"2025-10-15T21:52:50+00:00","article_modified_time":"2025-10-16T06:34:32+00:00","og_image":[{"width":777,"height":607,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/AdministrationReports.png","type":"image\/png"}],"author":"Alain Lacour","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Alain Lacour","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/"},"author":{"name":"Alain Lacour","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0"},"headline":"APEX IR Subscriptions #JoelKallmanDay","datePublished":"2025-10-15T21:52:50+00:00","dateModified":"2025-10-16T06:34:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/"},"wordCount":499,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/#primaryimage"},"thumbnailUrl":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/AdministrationReports.png","keywords":["APEX","JoelKallmanDay","Oracle","orclapex"],"articleSection":["Development & Performance","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/","url":"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/","name":"APEX IR Subscriptions #JoelKallmanDay - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/#primaryimage"},"thumbnailUrl":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/AdministrationReports.png","datePublished":"2025-10-15T21:52:50+00:00","dateModified":"2025-10-16T06:34:32+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0"},"description":"APEX Interactive Report Subscription allows to distribute reports via E-mail. Let's see how to bring some control into the game.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/AdministrationReports.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/AdministrationReports.png","width":777,"height":607},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/ir-subscriptions-joelkallmanday\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"APEX IR Subscriptions #JoelKallmanDay"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0","name":"Alain Lacour","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","caption":"Alain Lacour"},"description":"Alain Lacour has more than 15 years of experience in application development with Oracle technologies. He is specialized in APEX, Java, and PL\/SQL development. His expertise also includes middleware technologies such as Oracle Weblogic and EMC Documentum. He also has a broad experience in business analysis and architecture solutions as well as in service and project management. Prior to dbi services, Alain Lacour was Senior Consultant at IMS Health in Basel. He also worked as a Software Engineer for M&H Informatics in Basel. Alain Lacour holds a Master of Science in Industrial Computing from the University of Mulhouse (F). His branch-related experience mainly covers the pharma industry, with an in-depth knowledge of the drug development process as well as drug distribution.","url":"https:\/\/www.dbi-services.com\/blog\/author\/alain-lacour\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/41024","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=41024"}],"version-history":[{"count":16,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/41024\/revisions"}],"predecessor-version":[{"id":41052,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/41024\/revisions\/41052"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=41024"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=41024"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=41024"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=41024"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}