2. Oracle FCUBS - ILM Integration

The integration between the Oracle FLEXCUBE Universal Banking System (FCUBS) and Integrated Liquidity Management (ILM) enables the financial institutions to get value dated balance or credit-debit turnover for given set of accounts that participate in Liquidity Management.

This chapter contains the following sections:

• Section 2.1, "Scope"
• Section 2.2, "Prerequisites"
• Section 2.3, "Integration Process"
• Section 2.3, "Integration Process"
• Section 2.4, "Assumptions"

2.1 Scope

This section describes the scope of the integration with respect to FCUBS and ILM.

This section contains the following topics:

• Section 2.1.1, "Fetching Value Dated Balance through Webservice"
• Section 2.1.2, "Generating Balance Report at EOD through GI Batch"

2.1.1 Fetching Value Dated Balance through Webservice

You can fetch the value dated balance or credit-debit turnover through a webservice by providing the account details, balance type and value date.

2.1.2 Generating Balance Report at EOD through GI Batch

You can generate a balance file at EOD for all the accounts that participate in the Liquidity Management. This file will be uploaded into the ILM system for reconciliation.

2.2 Prerequisites

Set up Oracle FLEXCUBE Universal Banking Application and Oracle Global Liquidity Management Application.

Refer the ‘Oracle FLEXCUBE Universal Banking Installation’ manual.

2.3 Integration Process

This section contains the following topic:

• Section 2.3.1, "Fetching Value Dated Balance"
• Section 2.3.2, "Generating EOD Batch at EOD"

2.3.1 Fetching Value Dated Balance

You have to specify the account number, transaction date and balance type to query the value dated balance for a particular account.

You can specify the balance type as ‘VDBALANCE’ or ‘DRCRTURNOVER’. If the balance type is VDBALANCE then value dated balance will be returned. If the balance type is DRCRTURNOVER, then the sum total of debit/credit will be returned.

If the given value date has any back value dated entries then the response will return multiple values.

2.3.2 Generating EOD Batch at EOD

You can create a GI Batch to be run at EOD which will generate a balance file at branch EOD for all the accounts that participate in Liquidity Management.

You can create a UDF check box in User Defined Fields Maintenance (UDDUDFMT) screen and link it to Customer Accounts Maintenance (STDCUSAC) using UDDFNMNT. This check box should be enabled for all the accounts that participate in liquidity management.

2.4 Assumptions

Liquidity management should be enabled for the Customer Accounts, then GI will pick them up during EOD batch.