2.27 Criteria Code Maintenance

This topis describe about the detailed information on criteria code details.

Note:

The fields, which are marked with an asterisk, are mandatory.

User can define alert selection criteria in Oracle FLEXCUBE. The system identifies the set of customers who receive the alerts based on the selection criteria.

The system generates the alerts based on the selection criteria defined in Criteria Code Maintenance screen.

1. On the Home screen, specify GEDACMNT in the text box and click the icon.
   The Criteria Code Maintenance screen displays.

   Figure 2-69 Criteria Code Maintenance

   
   

   
   Description of "Figure 2-69 Criteria Code Maintenance"

   
   
2. On Criteria Code Maintenance screen, click New and specify the fields.
   For more information on fields, refer to the field description table.

   Table 2-94 Criteria Code Maintenance - Field Description

   Field	Description
   Criteria Code	Select a unique code that identifies the criterion that you are defining. To retrieve the criteria code click the F7 and F8 function keys. This code is the unique identifier of the criterion based on which alert is generated. The system does not allow you to modify the criteria code after saving it.
   Description	Specify a brief description of the selection criterion that you are defining.
   Select	Specify the select part of the selection criterion. The criterion must be defined as an SQL statement with aliases. However, user need not enter the keyword SELECT. The alias naming convention is ColX. Here, X refers to the sequential number of the column in the Select clause. Examples are s1.cust_ac_no Col1 ,s1.cust_no Col2 ,s1.ccy Col3 ,s1.account_class Col4 ,s1.ACY_OPENING_BAL Col5, s2.customer_name1 Col6, s2.language Col7, s2.default_media Col8 Based on the columns defined under Select and From and Where Clause, the system forms the final SQL statement. You need to ensure that the final SQL statement is a syntactically correct SQL statement.
   From and Where Clause	Specify the remaining part of the selection criterion. You need not enter the keyword From. Based on the columns defined under Select and From and Where Clause, the system forms the final SQL statement. User need to ensure that the final SQL statement is a syntactically correct SQL statement. Note: The From and Where Clause values and Alert Criteria Code values are already pre-defined in the system as these are factory shipped values.
   Final SQL Statement	The system concatenates the values defined under Select and From and Where Clause and displays the final SQL statement. This must be a valid SQL statement. The system generates the alert messages based on this final SQL statement. Once user have captured the details, save the record. To define the criteria as SQL statement, user needs to have sufficient understanding about the data model of Oracle FLEXCUBE and SQL programming language.

3. Click Execute Query to execute the record.

• Criteria Code Summary
  This topic describes about detailed information on viewing alert criteria definition summary.