1.2.4 Prerequisites in Oracle Lending and Loan Syndication

The prerequisites for this integration are as follows.

Parameter Setup

• If HANDOFF_TYPE value is SYNC in CSTB_PARAM table, then the balance check is performed using API or dynamic call.
• If HANDOFF_TYPE value is ASYNC in CSTB_PARAM table, then the consolidated amount to be requested is logged in ECA tables. Further processing, is performed by job.
• ECA_CHECK_REQD should be YES in CSTB_PARAM table for standalone system.
  • Static INC to support ECA Block and Unblock in OLTM_SERVICE_PARAMS and OLTM_SERVICE_REQ_FORMAT tables for SERVICE_CODE - CreateEca and DeleteEca, EXT_SERVICE_NAME - FCUBSCAService, EXT_OPERATION_CODE - CreateEcablk and CloseEcablk respectively.
  • Integration maintenance for FCUBSCAService Service in OLDINPRM for the new External Credit Approval System.

Maintenances

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:

Note The following data in OL and LS module must be in sync with those maintained in external system.

• Branch
• Contract Reference Number
• Account number
• Currency
• Dr/Cr