The following are the common core maintenance that needs to be completed for FCUBS, Payments, and ELCM systems integration.
You can configure the accounting system using host code in the ‘Host Parameter’ screen.
To invoke this screen, type ‘PIDHSTMT’ in the field at the top right corner of the application toolbar and click the adjoining arrow button.
Specify the following details
Host Code
Specify the host code.
Host Description
Specify the brief description for the host.
Accounting System Code
Specify the accounting system code.
Payment System
Specify the payment system.
ELCM System
Specify the ELCM system.
OBCL Integration System
Specify the external system. For example, OLINTSYS
You have to maintain integration parameters for ‘External LOV’ and ‘ELCM/Payment/OL Utilization’. This maintenance must be done for all branches. This maintenance is done through ‘Integration Parameters Maintenance’ screen.
To invoke this screen, type ‘IFDINPRM’ in the field at the top right corner of the application toolbar and click the adjoining arrow button.
Example of Integration Parameter Maintenance screen for Payments
Example of Integration Parameter Maintenance screen for ELCM
Example of Integration Parameter Maintenance screen for OBCL
You can specify the following fields in this screen:
Branch Code
Select the branch code for which the parameters are to be maintained from the adjoining option list.
Description
A brief description of the branch code is displayed.
External System
Select the external system for which the parameters are to be maintained, from the adjoining option list.
Description
A brief description of the external system is displayed.
Offset Transaction Code
Select a transaction code for the offset entry from the adjoining option list. The adjoining option list displays all valid transaction codes available in the system. You can select the appropriate one
Offset Amount Tag
Select an amount tag for the offset entry from the adjoining option list. The adjoining option list displays all valid amount tag available in the system. You can select the appropriate one
Amount Block Validation
Select this check box to validate the amount block. If the amount block reference number is sent with the transaction details then the accounting will be invoked after the release of amount block.
Offset Required
Select this check box if an offset entry is required. If this check box is selected, then ISB GL will be resolved based on branch, currency, function id and external system. If the check box is not selected, then it is expected that external system sends the balanced entry
Offset Netting Required
Select this check box if offset netting entry is required. If this check box is selected, then the consolidated entries will be built. Offset amount tag is picked from the maintenances. If this check box is not selected, then individual entries are built.
Allow Force Post
Select this check box to suppress all the overrides after posting transactions.
You need to maintain the integration parameters for the following:
External Lov
Note
Rest Service need not be maintained for OBCL.
ELCM Utilization/Payment/OBCL
The integration of OLand LS module with CASA enables banks to do the following:
This chapter contains the following sections:
This section describes the activities that take place in each system and its impact on the other.
This section contains the following topics:
If FCUBS is co-deployed with OL and LS module, then web service call is used to check the available balance.
The following are the integration activities that take place in Oracle Corporate Lending.
ECA Request for Auto Liquidation
ECA Handling during Auto Rollover
ECA Handling for Manual liquidation
Actions |
System Response |
After logging payment in ECA queue for approval, if you try to delete the payment before getting the response, then the status is W. |
The system should undo ECA if it gets approved response (Reconcillation mechanism) |
After getting ECA response as ‘Approved’, if you try to delete the payment |
The system should undo ECA with the approved block number |
ECA Handling for Manual Rollover
Account Interface and Handoff
Debit request+ <ECAREFNO> |
ECA Block is released |
Debit request |
Amount is debited from withdrawable balance |
Force debit Components
Tax, Fee and charge which are associated with liquidation/rollover event is debited from the account without ECA.
Forward Liquidation
This section contains the following topics:
Component |
Amount Due |
Account |
ECA Approved Amount |
Principal |
50000 |
CASA1 |
50000 |
Interest |
10000 |
CASA1 |
10000 |
In this case OL and LS module generates a single ECA request that contain details amount due from two accounts.
Component |
Amount Due |
Account |
ECA Approved Amount |
Principal |
50000 |
CASA1 |
50000 |
Interest |
10000 |
CASA2 |
10000 |
In this case request is not sent to ECA system, however it is marked as approved by OL and LS module in ECA tables and it proceeds with liquidation processing.
Component |
Amount Due |
Account |
ECA Approved Amount |
Principal |
50000 |
GL1 |
50000 |
Interest |
10000 |
GL2 |
10000 |
In this ECA request is sent only for CASA account and the GL it is marked as approved automatically. Liquidation processing happens irrespective of whether the ECA request is successful for the CASA account.
Component |
Amount Due |
Account |
ECA Approved Amount |
Principal |
50000 |
CASA |
50000 |
Interest |
10000 |
GL1 |
10000 |
In this case, the system proceeds with allocating the approved amount based on liquidation order specified at the product level.
Component |
Amount Due |
Account |
ECA Approved Amount |
Principal |
50000 |
CASA1 |
50000 |
Interest |
10000 |
CASA1 |
10000 |
In this case ECA request is sent with Partial allowed as ‘N’, hence the request is marked as failure if the full amount requested is not available.
Component |
Amount Due |
Account |
ECA Approved Amount |
Principal |
50000 |
CASA1 |
50000 |
Interest |
10000 |
CASA1 |
10000 |
This section contains the following topics:
The prerequisites for this integration are as follows.
Complete the following maintenances in Oracle Banking Corporate Lending to enable the integration.
Queue Name |
Purpose |
ECA_REQ_OUT |
Request to external system |
ECA_RES_IN |
Response from external system |
Table Name |
Purpose |
COTB_ECA_QUEUE |
ECA request details |
COTB_ECA_QUEUE_DETAIL |
ECA request components details |
Note
The following data in OL and LS module must be in sync with those maintained in external system.
This section contains the following topics:
ECA Queue Summary screen contains details on the transactions between OL/LS and external system.
To invoke this screen, type PISECAQU’ in the field at the top right corner of the application toolbar and click the adjoining arrow button.
You can search records based on the following parameters:
Click ‘Search’ button with or without entering any of the above search parameters. All records matching the search criteria are displayed. To view a particular record double-click on the desired record displayed in the list of records. The details pertaining to each record is displayed.
'External Accounting Log' screen contains OL/LS transaction details with External Accounting System linkage.
To invoke this screen, type ‘OLSEACLG’ in the field at the top right corner of the application toolbar and click the adjoining arrow button.
In this screen, you can view the request sent from OL and LS module and view the response (received for the request sent) from the External Accounting System.
You can search records based on the following parameters:
Click ‘Search’ button with or without entering any of the above search parameters. All records matching the search criteria are displayed. To view a particular record double-click on the desired record displayed in the list of records. The details pertaining to each record is displayed.
SWIFT payment message MT103 and MT202 are supported. If transfer type is ‘Customer Transfer’, then MT103 payment message is generated. If transfer type is Bank Transfer, then MT202 payment message is generated.
For OL/LS with Payments integration, you need to perform the following:
In Loan Syndication, SWIFT messages are triggered based on the components like PRINCIPAL, INT_LIQD, and FEE_LIQD.
This section contains the following topics:
Steps involved in processing of outgoing SWIFT messages.
You can view Oracle Lending and Loan Syndication contracts with payment integration in ‘Payment Outgoing Browser’ screen.
To invoke this screen, type ‘OLSPMTBR’ in the field at the top right corner of the application toolbar and click the adjoining arrow button.
In this screen, you can view the request sent from Oracle Lending/Loan Syndication module and view the response (received for the request sent) from the Payments module.
You can search records based on the following parameters:
Click ‘Search’ button with or without entering any of the above search parameters. All records matching the search criteria are displayed. To view a particular record double-click on the desired record displayed in the list of records. The details pertaining to each record is displayed.
Note
To search outgoing payment details, for LB side use DD Contract Reference Number and for LP side use Contract Reference Number
You can invoke the ‘ISB GL Maintenance’ screen by typing ‘OLDISBGL’ in the field at the top right corner of the application tool bar and by clicking the adjoining arrow button.
You can specify the following field information in this screen. A brief description of each value updated in the fields appearing in this screen, is displayed by the system.
External System
Select the external system from the adjoining option list.
Module ID
Select a valid module code from the adjoining option list.
Transaction Currency
Select a valid currency code from the adjoining option list.
Transaction Branch
Select a valid transaction branch code from the adjoining option list
Product Code
Select a valid product code from the adjoining option list.
Function ID
Select a valid function ID from the adjoining option list.
ISB GL
Select a leaf General Ledger from the adjoining option list.
The integration between OBCL and ELCM enables you to view the Oracle Lending and Loan Syndication contracts with ELCM linkage in a sync or async mode.
If you are booking a Oracle Lending and Loan Syndication contracts with ELCM linkage in a sync or async mode, the OLTB_REQ_MASTER table is updated with records. You can view these records in the External Limit Summary screen.
OLTB_REQ_MASTER table must have value.
Forward Init
As part of loan batch process for contract marked for initiation on processing date, the system picks and processes the 'FWDINIT' on processing date.After processing ‘FWDINIT’, the system sends a request to ELCM system (if any limits are linked to contract) for Utilization of contract amount.
After success response from the ELCM system, the system authorizes the ‘FWDINIT’ process.For failure response from ELCM system, the system roll backs the ‘FWDINIT’ process (after roll back contract details are logged into exception table)
Forward VAMI
As part of loan batch process for contract marked for VAMI on processing date, the system picks and processes the ‘FWDVAMI’ on processing date. After processing FWDVAMI, the system sends a request to ELCM system (If any limits are linked to contract) for Utilization/De-Utilization of contract amount.
After success response from the ELCM system, the system authorizes the VAMI process. For failure response from ELCM system, the system roll backs the FWDVAMI process (after roll back contract details are logged into exception table)
Auto Liquidation and Forward Liquidation
As part of loan batch process for contract marked for Liqudation on processing date, the system picks and processes the liquidation on processing date. After processing the system sends a request to ELCM system (If any limits are linked to contract) for Utilization/De-Utilization of contract amount.
After success response from the ELCM system, the system completes the liquidation process. For failure response from ELCM system, the system roll backs the liquidation process (after roll back contract details are logged into exception table)
ACCRUAL
As part of loan batch process for contract marked for ‘ACCRUAL’ on processing date, the system picks and processes the ‘ACCRUAL’ process on processing date. After processing accrual process, the system sends a request to ELCM system (If any limits are linked to contract) for Utilization/De-Utilization of contract amount.
After success response from the ELCM system, the system authorizes the accrual process. For failure response from ELCM system, the system roll backs the ‘ACCRUAL’ process (after roll back contract details are logged into exception table).
External Limit Summary screen contains details of the Oracle Lending and Loan Syndication transactions with ELCM linkage.
You can approve, resend, reject, and authorize the Oracle Lending and Loan Syndication transactions using this screen.
To invoke this screen, type OLSEXLMT’ in the field at the top right corner of the application toolbar and click the adjoining arrow button.
You can search records based on the following parameters:
Click ‘Search’ button with or without entering any of the above search parameters. All records matching the search criteria are displayed. To view a particular record double-click on the desired record displayed in the list of records. The details pertaining to each record is displayed.
The action log screen displays the details of actions performed in the External Limit Queue screen.
To invoke this screen, type ‘OLDQAHIS’ in the field at the top right corner of the application toolbar and click the adjoining arrow button.
This screen displays the action log of the following fields along with ‘Message Id’ and ‘Process Sequence Number’.
You can view service log using ‘View Service Log’ screen. To invoke this screen, type ‘OLDSRLOG’ in the field at the top right corner of the application toolbar and click the adjoining arrow button.