1.2.1 Prerequisites in Oracle FLEXCUBE Universal Banking

This topic describes about the prerequisites in Oracle FLEXCUBE universal banking.

The prerequisites for this integration are as follows.

Parameter Setup

In the CSTB_PARAM table, set the option FCIS_INSTALLED to Y. If this parameter is set to Y and FCIS_DBLINK is set, then the customers in the FCUBS system can have a unit holder relationship with the FCIS system. The system displays an error message if you try to close the customer account from FCUBS and the same account is an active unit holder in FCIS.

If the option FCIS_INSTALLED is Y and the parameter FCIS_DBLINK is not set, then the system displays a configurable override message as FCIS DBlink is Not Maintained.

In the CSTB_PARAM table, FCIS_USER and FCIS_MODULE are maintained. This has to be maintained in FCIS also. These parameter values will be fetched by the system and used in the FCIS web service FCISCustomerInquiry call from FCUBS for displaying the Fund Holdings of the given Customer.

Maintenances

To enable the integration, complete the following maintenances in Oracle FLEXCUBE Universal Banking.

• Bank Parameters: Basic information about the bank
• Branch Parameters: Details of head office, regional offices and branches.
• Messaging Queues: Maintain the following queues:

  Table 1-1 Messaging Queues

  Queue Name	Purpose
  MDB_QUEUE_REQUEST	Online transaction request.
  MDB_QUEUE_RESPONSE	Online transaction response.
  CIFCREATION_DEST_QUEUE	Notification from Oracle FCUBS.

For more information on these maintenances, refer to the Core Services user manual of Oracle FLEXCUBE Universal Banking.

Note:

The following data in FCUBS must be in sync with those maintained in the FCIS system.

• Bank code
• Branch code
• Currency
• Exchange rate source
• Investor category
• Investor type
• Title
• Country

Investment Customers

The Oracle FCUBS-FCIS integration is enabled only for customers who are marked as investment customers.

For further details on marking a customer as an investment customer, refer to the topic Investment Customer Creation or Modification.