X

Proactive insights, news and tips from Oracle Fusion Middleware Support. Learn Oracle from Oracle.

How to Broadcast Messages to Oracle Forms Users using System Notifications

Alexandra David
Principal Technical Support Engineer

In the new version, Oracle Forms 12c offers a number of new event oriented features.

A summary of the new features is presented in:  Oracle® Forms 12c New Features White Paper

In essence, System Events allow developers to develop applications that can react to actions that occur relative to the running application.

Below, a sequence of steps is presented on how to use the System Notification event to broadcast messages to all active Forms users or a specific subset of active users.
 
This scenario involves that the System Notification event will be raised when a notification has been received from Fusion Middleware Control (FMWC). 
FMWC can send one of five notification levels to any or all of the running Forms sessions from the Forms User Sessions page. 
Application Developers will code the desired action for each notification level. Notification levels are determined using the new System variable :SYSTEM.NOTIFICATION_VALUE. 
 
Here is an example of how to use the SYSTEM_NOTIFICATION event.
 
1. In Forms Builder, create an Event of type "System Notification".
 
2. Create a WHEN-EVENT-RAISED Trigger with code like the following:
BEGIN
-- NOTIFICATION_VALUE is the value/number sent from Fusion Middleware Control
    notification_level := :SYSTEM.NOTIFICATION_VALUE;
    If :SYSTEM.LAST_EVENT = 'SYSTEM_NOTIFICATION' Then
      CASE notification_level
      -- Each message should be customized as needed.
        WHEN '1' THEN MESSAGE ('Received Notification #1 from Fusion Middleware Control.');
        WHEN '2' THEN MESSAGE ('Received Notification #2 from Fusion Middleware Control.');
        WHEN '3' THEN MESSAGE ('Received Notification #3 from Fusion Middleware Control.');
        WHEN '4' THEN MESSAGE ('Received Notification #4 from Fusion Middleware Control.');
        WHEN '5' THEN MESSAGE ('Received Notification #5 from Fusion Middleware Control.');
    END CASE;
  End if;
END;
 
3. Log into Oracle Enterprise Manager Fusion Middleware Control 12c.
4. Bring up the User Sessions page to view the active sessions.
5. Select the "Notify" Button, and choose a Notification Message to send.
6. Based on the code above, the appropriate Message will be displayed in the Form.
 
A form example and specific details can be found in Doc ID 2120411.1
 
Also, useful information on this topic can be found in:
 
 

Join the discussion

Comments ( 1 )
  • Hassan Monday, December 3, 2018
    Dear Expats,

    can you provide complete step for broadcast message on oracle forms 12c, i can find the forms code but did not find the database AQ code or how to do on database levels,

    kindly share complete setps.

    Regards
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.