5.1 OBRH Integration
During Bank Implementation, assuming OBRH is installed and configured as part of either OBCM or OBSCF installation.
For OBAPI and OBSCFCM 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 product OBSCFCM (Oracle Banking Cash Management or Oracle Banking Supply Chain Finance) end-points configured in OBRH is “ASP”, “INV” and “SCFCM”.
- 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/OBSCFCM/version/DIGX_FW_CONFIG_ALL_O.sqlNote:
‘%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 OBSCFCM APIs that are integrated with OBAPI using OBRH
is as follows:
OBRH Consumer Service Name Transaction Name Description ASP_ASSOCIATEDPARTY_CREATEOnboard Associated Party This API is used to onboard an associated party. ASP_ASSOCIATEDPARTY_LISTView Associated Parties Fetches the list of associated parties. ASP_ASSOCIATEDPARTY_READView Associated Parties Fetches associated party details. ASP_ASSOCIATEDPARTY_UPDATEUpload KYC document for Non-Customer This API is used to update the document Id for a new associated party that is not a customer of a bank. ASP_ASSOCIATEDPARTY_RELATIONSHIPFetch Buyer-Supplier Relationship details This interface is used to fetch details of buyer-supplier relationship INV_INVOICES_CREATECreate Receivables/Payables This API is used to create invoices. INV_INVOICE_LISTView/Edit Receivables/Payables This API is used to fetch invoices INV_INVOICE_READView/Edit Receivables/Payables This API is used to fetch invoice details INV_INVOICES_UPDATE_STATUSManage Receivables/Payables This API allows a user to perform various operations on invoices like Edit, Cancel, Accept, Raise Dispute, Resolve Dispute etc INV_INVOICES_DISPUTE_REASONManage Receivables/Payables This API fetches list of dispute reasons required to raise dispute on an invoice. INV_LIST_COMMODITIESCreate Receivables/Payables This API fetches list of supplier based commodities. INV_CREDIT_NOTE_CREATECreate Credit Note This API is used to create credit notes INV_CREDIT_NOTE_LISTView Credit Note This API is used to fetch credit notes INV_CREDIT_NOTE_READView Credit Note This API is used to fetch credit note details SCFCM_PARAMS_LISTOnboard Associated Party This API fetches application params. SCFCM_PAYMENTS_LISTView Payments This API is used to fetch the list of payments. SCFCM_PAYMENT_READView Payment Details This API is used to fetch payment details. SCFCM_MANUAL_RECONCILIATIONManual Reconciliation This API is used to manually reconcile cashflows/invoices with payments SCFCM_LIST_RECONCILED_TRANSACTIONSDe-Reconciliation This API is used to fetch the list of reconciled cashflows/invoices. SCFCM_DERECONCILEDe-Reconciliation This API is used to de-reconcile already reconciled cashflows/invoices. SCFCM_RECONCILIATION_RULE_LISTView/Edit Reconciliation Rules Fetches list of reconciliation rules maintained for a party. SCFCM_RECONCILIATION_RULE_CREATECreate Reconciliation Rule This API is used to create reconciliation/allocation rule for a party. SCFCM_RECONCILIATION_RULE_UPDATEEdit Reconciliation Rule This API is used to modify reconciliation/allocation rule details for a party. SCFCM_RECONCILIATION_RULE_READView Reconciliation Rule details Fetches reconciliation rule details. SCFCM_LIST_RECONCILIATION_CATEGORIESView/Edit Reconciliation Rules Fetches reconciliation categories SCFCM_LIST_RECONCILIATION_ATTRIBUTESView/Edit Reconciliation Rules Fetches reconciliation attributes SCFCM_LIST_ALLOCATED_TRANSACTIONSView Payment Details This API is used to fetch allocation details of a payment. SCFCM_LIST_ALLOCATION_ACCOUNTSManual Allocation This API is used to fetch virtual accounts which can be further allocated to payments. SCFCM_MANUAL_ALLOCATIONManual Allocation This API is used to manually allocate payments to virtual account.
This completes the entire configuration needed for consuming OBSCFCM APIs in OBAPI through OBRH.
We need to execute below script to fetch mid office token required for fetching associated party information for non-customer.
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 ('tokenASP144','http://${ASP_HOST_IP}:${ASP_HOST_PORT}',
'api-gateway/platojwtauth', 'application/json','application/json', 'N', 'Bearer',
'credential_impl', 'ASP_14.4', sysdate, sysdate);
We need to execute below script to fetch mid office token required for Invoice/Debit-Credit Note 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 ('tokenINV144','http://${INV_HOST_IP}:${INV_HOST_PORT}', 'api-gateway/platojwtauth',
'application/json', 'application/json', 'N', 'Bearer', 'credential_impl', 'INV_14.4',
sysdate, sysdate);
Parent topic: Receivables/Payables Management