7.1 OBRH Integration

During Bank Implementation, assuming OBRH is installed and configured as part of OBCM installation.

For OBAPI and mid Office OBCM integration using OBRH the following configurations need to be done.

1. Carry out all the steps mentioned inOBRH Integration Configurationsection in this document. The service provider for mid-office product OBCM (Oracle Banking Cash Management) end-points configured in OBRH is “OBCM”
2. After all the above steps are completed, user needs to execute some scripts for the host APIs that are to be consumed via OBRH. These are the scripts to pick the third party adapter implementation instead of the host specific implementations as well as to call the OBRH end-point for the configured interfaces. The scripts are available at the following location:

   /Installables/db/OBCM/version/DIGX_FW_CONFIG_ALL_O.sql

   Note:

   ‘%ENTITY_ID%’ should be replaced with the entity identifier (For Example if the entity during implementation is OBDX_BU then ‘%ENTITY_ID%’ should be replaced by ‘OBDX_BU’).
3. The list of OBCM APIs that are integrated with OBAPI using OBRH is as follows:

   OBRH Consumer Service Name	Transaction Name	Description
   CMS_CASHFLOW_TRANSACTION_READ	View/Edit Expected Cash Flow Details	Fetches Cashflow Details
   CMS_CASHFLOW_TRANSACTION_UPDATE	View/Edit Expected Cash Flow Details	This API is used to modify expected cashflow details.
   CMS_CASHFLOW_FETCH	Cashflow Forecasting	This API is used to fetch cashflow forecasting data.
   CMS_CCM_LIST	Cash Deposits	This API is used to fetch collection maintenance details of a cash management.
   CMS_DIVISION_CODE_LIST	Cash & Cheque Deposits	This API is used to fetch division code details of a given party.
   CMS_CASH_DEPOSITS_CREATE	Cash Deposits	This API is used to create multiple cash deposits for a party.
   CMS_CASH_DEPOSITS_LIST	View Cash Deposits	This API is used to fetch cash collections.
   CMS_CASH_DEPOSIT_READ	View Cash Deposit Details	This API is used to fetch cash collection details.
   CMS_CHEQUE_LIST	View Cheque Deposits	This API is used to fetch cheque collections.
   CMS_CHEQUE_READ	View Cheque Deposit Details	This API is used to fetch cheque collection details.
   CMS_BRANCH_DENOMINATION_LIST	Cash Deposits	This API is used to fetch denomination details for a particular branch.
   CMS_BRANCH_CODE_LIST	Cash & Cheque Deposits	This API is used to fetch all the branch.
   CMS_CASH_DEPOSIT_VALIDATE	Cash Deposits	This API is used to validate cash/cheque number uniqueness.
   CMS_CMM_LIST	Cash Deposits	This API is used to fetch maintenance details of a cash management.
   CMS_CASH_WITHDRAWAL_LIST	View Cash withdrawal	This API is used to fetch cash withdrawal collections.
   CMS_CASH_WITHDRAWAL_READ	View Cash withdrawal details	This API is used to fetch cash withdrawal collection details.
   CMS_CASH_WITHDRAWAL_CREATE	Create Cash withdrawal	This API is used to create cash withdrawal for a party.
   CMS_CHEQUE_DEPOSITS_CREATE	Cheque Deposits	This API is used to create multiple cheque deposits for a party.
   CMS_CASHFLOW_CODE_LIST	Cashflow Forecasting	This API is used to fetch cash flow code details.
   CMS_ROUTING_LIST	Cheque Deposits	This API is used to fetch routing details.
   CMS_COLLECTION_LIST	Overview Collection summary	This API is use to fetch collection summary details for cash/cheque & cash withdraw.
   CMS_PDM_LIST	Pick up & delivery	This API is use to fetch pickup and delivery details.

This completes the entire configuration needed for consuming OBCM APIs in OBAPI through OBRH.

We need to execute below script to fetch mid office token required for Cashflow/Payment File Upload.

INSERT INTO DIGX_FW_CONFIG_OUT_RS_CFG_B 
(SERVICE_ID, CONTEXT_URL, SERVICE_URL, REQUEST_MEDIA_TYPE, RESPONSE_MEDIA_TYPE, AUTHENTICATION, 
AUTH_TYPE, CREDENTIAL_STORE_TYPE, CREDENTIAL_STORE_KEY, CREATION_DATE, LAST_UPDATED_DATE) 
VALUES ('tokenOBCM144', 'http://${OBCM_HOST_IP}:${OBCM_HOST_PORT}', 'api-gateway/platojwtauth',
'application/json', 'application/json', 'N', 'Bearer', 'credential_impl', 'OBCM_14.4',sysdate, sysdate);