Previous Next JavaScript must be enabled to correctly display this content

## 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.
   `CMS_FEEDFILE_SYNC_STATUS` | Cash flow file upload sync status | This API is used to fetch the status of the file that is being uploaded.
   `CMS_FETCH_ACCOUNT_DETAILS` | Fetch Account Details | This API is used to fetch account details
   `CMS_FETCH_BALANCE_BY_GROUP` | Fetch Balance by group | This API is used to fetch balance group by, and group can either entity or currency or location
   `CMS_FETCH_BALANCE_BY_IDENTITY` | Fetch Balance Details | This API is used to fetches balance by identity based on selected group
   `CMS_FETCH_MAINTENANCE` | Fetch Cash Visibility Management | This API is used to retrieve maintenance details for a cash visibility.
   `CMS_COLLECTION_DELETE` | Cancel collection | This API is used to delete or cancel collection initiated by OBDX user and has in request state
   `CMS_BULK_UPLOAD` | Cash flow file upload | This API is used to upload bulk cash flow files.
   `CMS_CASHFLOW_FETCH` | Cashflow Forecasting | This API is used to retrieve cash flow forecasting data.

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);

Parent topic: Cash Management System