Display Notifications on the Region in Oracle APEX

Usually, we display notifications on the navigation bar. But sometimes, you may require to show the notification on a particular region. Especially on report or chart regions, to show the newly added rows. In this Oracle APEX tutorial, I am giving an example to show the notification on the regions in a page.

To show the notifications on a region in Oracle APEX as shown in the below image, follow these steps:

a region in Oracle Apex." class="wp-image-6634"/>

Show Notification on a Report Region in Oracle APEX

1. Open the page and select the region on which you want to show the notification.
2. Select template type as Standard.
3. Create a hidden page item in that region. For example, the name of the item is P1_NOTI.
4. Set the default value for that item and set the type as SQL query, and specify the following SQL query, for example, select count(1) from emp where hiredate = sysdate;
5. Now specify the region title as follows: My Report <span class="notification" data-count="&P1_NOTI.">&P1_NOTI.</span>.
6. Specify a static ID to the region—for example, myReport.
7. You are almost done, now add the below CSS in the page's Inline CSS section:

#myReport .notification {
position: absolute;
top: -13px;
left: 86px;
padding: 6px 12px;
border-radius: 90%;
background: red;
color: white;
}
.notification[data-count="0"]{display:none;}

Save the changes and run the page. You will see the notification as per your data configuration.

You may need to set the CSS part left:86px; according to your title length.

The notification will display if the value is greater than 0; for the 0 value, it will not show the notification.