Notification On Oracle Apex

Notification on Navigation Bar in Oracle Apex

Topic Introduction: In this post, we will discuss how to show Notification on Navigation Bar in Oracle Apex. to users  It can be leave approval, accounts approval, etc. To deploy this work on your workspace follows the given instruction below.

1. Need to create an Application Items name G_CAPP_NOTIFICATION

Application >Shared Components >Application Items

Name: G_CAPP_NOTIFICATION

Scope: Application

2. Need to create an Application Computations where we declare the notification value by Query.

Application >Shared Components >Application Computations

Computation Item: G_CAPP_NOTIFICATION

Computation Point: Before Header

Computation Type: SQL Query (return single value)

Computation: 

SELECT COUNT(APPROVAL_STATUS) 

FROM COS_DCOLL_MST 

WHERE APPROVAL_STATUS<>'Y'

3. Need to create a Navigation Bar List name Notification where we want to see the notification. 

Application >Shared Components >Navigation Bar List> Desktop Navigation Bar

List Entry Label:  Notification

Target type: No Target

Badge Value: &G_CAPP_NOTIFICATION.

List Item CSS Classes: u-color-8

Note: 

1. During creation of Application Computations Computation Type can be others way to return notification value.

2. On Navigation Bar List creating List Item CSS Classes is not mandatory if we want any customize color then can be use this.