1.1 Notification Development

This topic provides an overview of the Notification Development process.

Prerequisite for Notification development and testing

Following are the prerequisite for notification development:
  • Target FLEXCUBE Environment with Notification framework installed.
  • Development Workbench link mapped to the FLEXCUBE environment.
  • Required Query Web services developed and tested.

Figure 1-1 Architecture- Notification Development

Notification specification

Identify the notification requirement as below:
  • What is the Notification function ID name for RAD XML (the Third character should be N)?
  • What is the Notification code?
  • What is the Base table in FLEXCUBE UBS that triggers the notification?
    • What operation at base table triggers (insert/update/delete)?
    • What is the where clause for the filter?
  • What is the query Web service to be used?
    • What is the operation?
    • What are the tags required?
For Example:
  • Notification function ID name – STNCUMOD
  • Notification code – NOTIF_CA_CUSTACC_MOD
  • Base table - STTM_CUST_ACCOUNT
    • Operation – DELETE
    • Filter – Account class type in (S,U)
  • Web service to be used – FCUBSAccService
    • Operation – QueryCustAcc
    • Request node – Cust-Account-IO

Notification XML development

Notification RAD XML development creates the following files:
  • RAD XML
  • SPC
  • SQL
  • Static Data

Notification Process

There will be one trigger for the base table of notification and in case of multiple notifications sharing the same base table, there will be no new triggers created. Instead, the same trigger created on the base table will be reused. This approach reduces the number of triggers being used for notifications.

Development process in Development Workbench

The notification development process in Workbench is split into two steps:
  1. Notification Triggers
  2. Notification Filter Procedure
The first step is to create notification triggers for base tables. The trigger generated from Workbench will be inserting key details into a static notification log table. The following details will be captured:
  • Trigger code: A unique value for a notification trigger.
  • Base Table: The base table on which, the trigger is built.
  • When Clause: A simple when clause for the notification trigger.
The second step is to capture the details of notifications and generate the notification filter procedure. The following details are captured:
  • Notification code: A unique value to identify a notification.
  • Description: Meaningful description of the notification.
  • Gateway Service

Parent topic: Notification – Getting started