The Oracle FLEXCUBE Enterprise Limits and Collateral Management (hereafter referred to as Oracle FLEXCUBE ELCM) system’s Gateway processes allow seamless communication and integration with variety of other specialized applications. These other systems maybe deployed on different platforms and may use different infrastructure. The Gateway bridges the external system and the Oracle FLEXCUBE ELCM system.
Oracle FLEXCUBE Enterprise Limits and Collateral Management Gateway provides two main kinds of processes:
This chapter contains the following sections:
Gateway Online process provides following process:
Following are the transactions supported by Gateway process:
Below table specifies the maintenance transactions supported by Gateway Online Process
Transaction |
Creation and Modification |
Delete |
Auth |
Close & Reopen |
Query |
Notify |
Tech Undo |
Customer |
Yes |
Yes
|
Yes
|
Yes
|
Yes
|
No |
No |
Liability |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Facility |
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
No |
Yes
|
Collateral |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Collateral Pool |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
No |
Issuers |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
No |
Securities |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
No |
Limits Transfer |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
No |
Account Service |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
No |
Below table specifies the Utilization transactions supported by Gateway Online Process.
Utilization Transactions |
Input |
Authorization |
Deletion |
Technical undo |
New Utilization |
Yes |
Yes |
Yes |
Yes |
Increase Utilization |
Yes |
Yes |
Yes |
Yes |
Decrease Utilization |
Yes |
Yes |
Yes |
Yes |
Alter Utilization |
Yes |
Yes |
Yes |
Yes |
Reverse |
Yes |
Yes |
Yes |
Yes |
Set Balance |
Yes |
Yes |
Yes |
Yes |
Query Utilization |
Yes |
Yes |
Yes |
Yes |
The Batch processes which can be triggered using Gateway Online Process:
During the processing of Gate Way online transactions some of the transactions processing may be fail because of a lock in the database. Oracle FLEXCUBE ELCM provides a feature to process the locked records.
This feature of Gateway allows the external system to rollback previously entered transactions in Oracle FLEXCUBE ELCM. This feature will be supported in Gateway Inbound (online), information required as part of Technical undo is also Transaction Id of the previous transaction. Technical undo is not supported for Query and Notification transactions.
Gateway Online processes are mainly used to process single transaction. Gateway Batch process is used when high volume of data needs to be transferred from external system to Oracle FLEXCUBE ELCM system or vice-versa. Communication format for the Gateway Batch process would be through ASCII file and data within the file is delimited with a Delimiter Character. All interface transaction file formats are predefined in the Oracle FLEXCUBE ELCM system.
Gateway Batch Process provides two kinds of process
Oracle FLEXCUBE ELCM Batch Inbound process is used to upload large records. As a batch operation the necessary input files are fetched from the mentioned location path. The Batch Inbound process can also be initiated from the following screen:
Batch Operation ->In Bound Batch ->detailed
The following operations (through input files) are supported as an Input Files Batch Operations:
Utilization Upload
All the utilizations as part of Oracle FLEXCUBE ELCM Transaction functions are provided for as a part of Batch Inbound operations. Utilization upload allows more than one utilization record to be uploaded in a single upload process.
Liability Upload
Liability creation as a part of batch upload is provided. Liability upload allows more than one Liability record to be uploaded in a single upload process.
Facility Upload
Facility creation as part of batch upload is provided. Facility upload allows more than one Facility record to be uploaded in a single upload process.
Collateral Upload
Collateral creation as part of batch upload is provided. Collateral upload allows more than one Collateral record to be uploaded in a single upload process.
Securities Upload
Securities creation as part of batch upload is provided. Securities upload allows more than one Securities record to be uploaded in a single upload process.
Customer Upload
Customer creation as part of batch upload is provided. Customer upload allows more than one Customer record to be uploaded in a single upload process.
Rates Upload
Rates creation as part of batch upload is provided. Rates upload allows more than one Customer record to be uploaded in a single upload process.
Oracle FLEXCUBE ELCM Batch Outbound process is used to upload large records. As a batch operation the necessary output files are generated into the mentioned work path. You can initiate the Batch Outbound Process using the following screen.
Batch Operations ->Out Bond Batch ->Detailed
The following operations are supported as an Input Files Batch Operations.
Utilization Handoff (For the Current Day)
All the utilizations which have occurred during the day can be grouped into a file. This file is a part of batch handoff operation. This file contains only the current day’s utilization records.
Liability Handoff (Zero Based)
All the Liabilities created in Oracle FLEXCUBE ELCM can be grouped in to file through the Batch Facility Handoff. This handoff contains all the details of the records.
Facility Handoff (Zero Based)
All the facilities created in Oracle FLEXCUBE ELCM can be grouped into file through the Batch Facility Handoff. This handoff contains all the details of the records.
Collateral Handoff (Zero Based)
All the Collateral created in Oracle FLEXCUBE ELCM can be grouped into file through the Batch Facility Handoff. This handoff contains all the details of the records.
The following interfaces are available as part of the Oracle FLEXCUBE ELCM system.
Module |
Interface Name |
Interface Type |
Currency |
Rates Interface |
Online incoming |
Core |
Product Interface |
Batch Incoming |
Branch Holiday |
Holiday Interface |
Batch Incoming |
SMS |
User Interface |
Batch Incoming |
Account |
Account Interface |
Online Incoming |
TD |
TD Interface |
Online/Batch Incoming |
TD |
TD block/unblock Interface |
Online/Batch Incoming |
Core |
Liability Link Interface |
Online/Batch Incoming |
Limits |
Facility Interface |
Batch Outgoing |
Limits |
Utilization interface |
Batch Outgoing |
Limits |
Dual Authorization |
Online Outgoing |
The integration between ELCM and Oracle Revenue and Billing Management (ORMB) enables you to fetch the pricing details from external pricing and billing system.
The following parameter set up is required for this integration during installation of ELCM.
For more information about this option, refer to Maintaining Rule, Maintaining Fee Class, and Facilities Maintenance sections.