The topic describes overview of the notification process.

The notification process is in two layers. In the first layer the notification process as part of jobs in the FCJ scheduler sends minimal data required for notification to an internal JMS queue. In the second layer the notification process as part of an MDB that listens on internal JMS queue builds final notifications and sends them to their intended destinations.

The Notification Process in Oracle Banking Corporate Lending using the jobs scheduler is as follows:

1. The trigger on the base table inserts key details into a static notification log table instead of Oracle AQ.
2. Once the Job is triggered, a request is sent to the EJB layer from the job execution class and the notification log table is polled for unprocessed records.
3. Each unprocessed record is locked.
4. The record is verified against the notification maintenance and checked whether notification is to be sent or not.
5. If a notification is to be sent, a pre-notification message XML is built and it is sent to internal notify_queue(JMS queue).
6. The job is then rescheduled to fire next time based on the previous execution.

Figure 1-4 Flow Chart of Notification Process in Scheduler

Description of "Figure 1-4 Flow Chart of Notification Process in Scheduler"

The notification process in MDB is as follows:

1. The Notification MDB listens on the internal notify JMS queue
2. On any message received, the MDB identifies which schema to connect using the JNDI name being present as part of the message XML.
3. Gateway notification processing package is called from MDB in order to build the actual notifications.
4. In MDB the notifications built is processed and sent to the destination specified in corresponding notification.
5. In case of any exception, the whole transaction is rolled back.
6. If all notifications are successfully processed then the transaction is committed.

Figure 1-5 Flow Chart of Notification Process in MDB

Description of "Figure 1-5 Flow Chart of Notification Process in MDB"