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.
- 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”
- 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’). - 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