8. Annexure 3 - Gateway Processes & Interfaces
The Oracle Banking Enterprise Limits and Collateral Management (hereafter referred to as Oracle Banking 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 Banking ELCM system.
Oracle Banking Enterprise Limits and Collateral Management Gateway provides two main kinds of processes:
- Gateway Online process
- Gateway Batch process
This chapter contains the following sections:
- Section 8.1, "Gateway Online Process"
- Section 8.2, "Gateway Batch Process"
- Section 8.3, "Interfaces"
8.1 Gateway Online Process
Gateway Online process provides following process:
- Online Inbound process
- Online Outbound process
Following are the transactions supported by Gateway process:
- Maintenance transactions
- Utilization transactions
- Batch process
8.1.1 Maintenance Transactions
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 |
8.1.2 Utilization Transactions
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 |
8.1.3 Batch Process
The Batch processes which can be triggered using Gateway Online Process:
- EOD Process
- Input File Process
- Output File Process
8.1.4 Reprocessing Locked Online Transactions
During the processing of Gate Way online transactions some of the transactions processing may be fail because of a lock in the database. Oracle Banking ELCM provides a feature to process the locked records.
8.1.5 Technical undo (Functional Rollback)
This feature of Gateway allows the external system to rollback previously entered transactions in Oracle Banking 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.
8.2 Gateway Batch Process
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 Banking 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 Banking ELCM system.
Gateway Batch Process provides two kinds of process
- Batch Inbound Process
- Batch Outbound Process
8.2.1 Batch Inbound Process
Oracle Banking 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:
- Customer upload
- Utilization Upload
- Liability upload
- Facility upload
- Collateral upload
- Securities upload
- Rates upload
Utilization Upload
All the utilizations as part of Oracle Banking 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.
8.2.2 Batch Outbound Process
Oracle Banking 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
- Liability
- Facility
- Collateral
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 Banking 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 Banking 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 Banking ELCM can be grouped into file through the Batch Facility Handoff. This handoff contains all the details of the records.
8.3 Interfaces
The following interfaces are available as part of the Oracle Banking 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 |
8.4 ELCM Integration with ORMB
8.4.1 Introduction
The integration between ELCM and Oracle Revenue and Billing Management (ORMB) enables you to fetch the pricing details from external pricing and billing system.
8.4.2 Parameter Set Up
The following parameter set up is required for this integration during installation of ELCM.
- In 'CSTB_PARAM' table, set the 'ELCM_PRICING_INTEGRATION' parameter as 'Y'. Only, if this option is set to 'Y', you can fetch the pricing details from external pricing and billing system.
- You need to enable the 'External Pricing Required' option in the
following screens.
- GEDRULES
- GEDCLSMT
- GEDFACLT
For more information about this option, refer to Maintaining Rule, Maintaining Fee Class, and Facilities Maintenance sections.