In Flexcube, whenever there is some event occur such as a new customer is created, an account balance is updated and so on, Flexcube will generate corresponding notification Flexcube format XML message and send out to external system. Notification is used to interface with external systems.

Notification Process Flow

Key Tables/Procedure

Name

Type

Usage

GWPKS_NOTIFICATION_FCJ

Package

Entry point for the notification

gwtm_notifications_master

Table

Master table storing all the notification infornation

gwtm_notifications_installed

Table

Table about the notification enable in which branch information

gwpks_notif_filter_wrapper

Package

Second entry pont

gwtbs_notifications_log

Table

Logging table for the notification information

sttb_notification

Table

Table storing the notification key information, status =U means unprocessed, P= processed

Pr_Populate_Notification

Procedure

To insert, update data in sttb_notification table

1.       Trigger GWTR#_XXXX listen to key tables, if there is any operation such as insert, update on these table, the trigger will be invoked and Pr_Populate_Notification is called to insert the key information into sttb_notification with status as ‘U’-unprocessed

2.       Scheduler is checking on this table and if find any record with status as ‘U’, will pick up the record and form a XML format message with the key information in the table

3.       The schedule and then pass the message to an intermediate queue

4.       GWNotifyMDBBean that listening to the intermediate queue and then get the message, and pass the message to Flexcube GWPKS_NOTIFICATION_FCJ package

5.       GWPKS_NOTIFICATION_FCJ is then checking in gwtm_notifications_master, gwtm_notifications_installed tables to see if this message should be processed further or not

6.       If this message is valid and needs to be processed, then gwpks_notif_filter_wrapper. Fn_Process_Msg is invoked to process the message

7.       gwpks_notif_filter_wrapper is then call the corresponding notification package for that notification, the package name is: MMPKS_NNNNNN_MAIN.fn_main (MM: the module code; NNNNNN the notification_id in gwtm_notifications_master table)

8.       The corresponding notification package is then do processing based on the key XML information and then form a full response XML

9.       The full response XML is then processed by GWNotifyMDBBean and finally send out to the Notification destination queue

ITPub博客

Flexcube Notification Flow

最新文章

Name	Type	Usage
GWPKS_NOTIFICATION_FCJ	Package	Entry point for the notification
gwtm_notifications_master	Table	Master table storing all the notification infornation
gwtm_notifications_installed	Table	Table about the notification enable in which branch information
gwpks_notif_filter_wrapper	Package	Second entry pont
gwtbs_notifications_log	Table	Logging table for the notification information
sttb_notification	Table	Table storing the notification key information, status =U means unprocessed, P= processed
Pr_Populate_Notification	Procedure	To insert, update data in sttb_notification table