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:
-- NOTIFICATION_VALUE is the value/number sent from Fusion Middleware Control
notification_level := :SYSTEM.NOTIFICATION_VALUE;
If :SYSTEM.LAST_EVENT = 'SYSTEM_NOTIFICATION' Then
-- 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.');
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: