6.10 Consumer Services– Finance Dedupe
This topic describes about the consumer services required for Finance Dedupe Implementation.
The following endpoints need to be set up under Consumer Services in the Oracle Banking Routing Hub::
- REGISTER
- STATUS
- FINANCINGS
- CANCELLATIONS
- CANCELLATIONS STATUS
Figure 6-11 Consumer Services - Finance Dedupe
REGISTER
To register the Invoice with an external partner i.e., MonetaGo.
SERVICE-CONSUMER = “OBSCFCM_FINANCE_DEDUPE”
SERVICE-CONSUMER-SERVICE = “REGISTER”
Request:
{
"branchCode" : "004",
"audience" : "https://api.uat.securefinancing.com",
"clientId" : "77QdQGPI6aXS0aKY6bua2SgyyXIoxwjG",
"isLoggingRequired" : false,
"documentType" : "CINV",
"clientSecret" :
"442t9wuejDJANnZBZMYNJ_KCGDCZ-7VHAbagSeq8_o5oVNJeLIVy1g7dVvhnpUhN",
"submitFinancialInstitutionId" :
"3ac506ec-8b62-4eab-b4c3-0dead0bc9f21",
"invoiceDetails" : [ {
"srcAppCd" : "EXT",
"srcAppCdStr" : null,
"id" : "1348976581746876416",
"seqNo" : 1,
"invoiceId" : "2022110900000000000000000000000000000422",
"isNettingFlag" : null,
"acceptanceAmount" : 10000,
"amount" : 10000,
"buyerId" : "202291","buyerName" :
"ATDPBUYER",
"buyerDivCode" : null,
"buyerDivName" : null,
"currency" : "USD",
"isDisputed" : null,
"discrepancyCode" : null,
"disputeResolveRemarks" : null,
"fileName" : null,
"fileRef" : null,
"filler1" : "2022-10-20",
"filler2" : null,
"filler3" : "Filler3-1",
"filler4" : "Filler4-1",
"filler5" : null,
"filler6" : null,
"filler7" : null,
"filler8" : null,
"filler9" : null,
"filler10" : null,
"financeAmount" : 0,
"financePercentage" : 0,
"indicator" : "I",
"invoiceDate" : "2022-10-20",
"invoiceDueDate" : "2022-11-04",
"invoiceNumber" : "ATDPINV-005",
"invoiceProcessStatus" : "SUCCESS",
"invoiceRefNo" : "INV0451",
"invoiceStatus" : "OVERDUE",
"invoiceStatusOther" : null,
"invAcceptanceDate" : "2022-11-09",
"maxFinancePercentage" : null,
"paidAmount" : 0,
"paymentStatus" : "UNPAID",
"preAccepted" : "Y",
"poNumber" : null,
"programCode" : "ATDPRG",
"programName" : "ATDPRG",
"reasonCode" : null,
"remarks" : "Remarks",
"supplierId" : "202292",
"supplierName" : "ATDPSUPPLIER",
"supplierDivCode" : null,
"supplierDivName" : null,
"taxAmount" : 0,
"totalInvoiceAmount" : 10000,
"assignmentAmount" : 0,
"assignableAmount" : null,
"minAssignableAmount" : null,
"maxAssignmentPct" : null,
"minAssignmentPct" : null,
"paymentTerms" : "Payment Terms",
"shipmentDate" : "2023-01-09",
"outstandingAmount" : 10000,
"discountAllowed" : "Y",
"discountPercentage" : null,
"discountAmount" : 0,
"taxPercentage" : null,
"purchaseOrderDate" : "2023-02-09",
"staleStatus" : "N",
"divisionCode" : "D1",
"shipmentAddress" : "Pune-411021",
"shipmentCountry" : "USA",
"shipmentNo" : "SH-01",
"reasonForExport" : "Not Specified",
"termsOfSale" : "FCA",
"countryOfOrigin" : "IND", "miscCharge1" :
null,
"miscCharge1Amount" : 0,
"miscCharge1Desc" : null,
"miscCharge2" : null,
"miscCharge2Amount" : 0,
"miscCharge2Desc" : null,
"netInvoiceAmount" : 10000,
"financeableAmount" : null,
"minFinanceableAmount" : null,
"finTxnStatus" : null,
"transactionRefNo" : "004110325INV1464",
"relationCode" : "ATDPRELATION",
"supplierCode" : null,
"buyerCode" : null,"shipmentRefNo" :
null,
"repayAccountNo" : null,
"bank" : "Bank01",
"branch" : "004",
"routingCode" : null,
"isAutoAuth" : null,
"reasonErrorCode" : null,
"isApproved" : null,
"shipmentCity" : null,
"shipmentZipCode" : null,
"shipmentPhoneNumber" : null,
"shipmentTaxId" : null,
"financeStatus" : null,
"invoiceCommodityGridList" : [ ],
"finEligibilityAmt" : null,
"reconTxnStatus" : null,
"reasonForShipment" : null,
"virtualAcFlag" : null,
"fundingReqAmt" : null,
"raisedBy" : null,
"processingBranchCode" : "004",
"action" : "CREATE",
"processingDate" : null,
"paymentDate" : null,
"disputedAmount" : null,
"linkedDocs" : null,
"isFinanced" : null,
"tcmId" : null,
"makerId" : null,
"makerDtStamp" : null,
"stageId" : null,
"isAccepted" : "Y",
"isDisputeResolvedWriteOff" : null,
"isAssigned" : null,
"assignmentParty" : null,
"isOverdue" : "Y",
"oldAcceptanceAmount" : null,
"oldAssignmentAmount" : null,
"oldFinanceAmount" : null,
"amountToBeFinanced" : null,
"oldInvoiceDueDate" : null,
"oldDisputeAmount" : null,
"sourceTxnId" : "EXT004110325INV1464",
"adjustmentReason" : null,
"linkInvoiceNumber" : "",
"paymentDueDate" : "2022-11-04",
"isPUA" : null,
"isIndirectPayment" : null,
"paymentParty" : null,
"importFactorId" : null,
"importFactorName" : null,
"insuranceCoId" : null,
"insuranceCoName" : null,
"paymentMode" : null,
"reconPmtAmount" : 0,
"reconPmtAmountCcy" : null,
"varianceAmount" : null,
"linkedInvoiceList" : null,
"invoiceOfferList" : null,
"feedSerialNo" : null,
"expiresOn" : null,
"fundingReqDate" : "2022-10-25",
"newFundingReqDate" : "2022-10-25",
"oldExpiryDate" : null,
"bunchIdentifier" : null,
"discountType" : null,
"invoiceValueDate" : null,
"discount1Days" : null,
"discount2Days" : null,
"discount1Perc" : null,
"discount2Perc" : null,
"paymentCondition" : null,
"exportFactorId" : null,
"exportFactorName" : null,
"validateForOverdue" : null,
"shipSeqNo" : 1,
"finSeqNo" : 1,
"paySeqNo" : 1,
"channel" : "EXT",
"corporateId" : null,
"financeOutstandingAmount" : null,
"interestBearingPartyRole" : null,
"tmDrCrNoteLinkInvoiceList" : [ ],
"nettingStatus" : null,
"invoiceLinkedPoModelList" : null,
"paymentThreshold" : null,
"appliedDiscountAmt" : null,
"creditCoverAmount" : 0,
"isUnderlyingPoFinanced" : null,
"messageRefId" : null,
"notifyingParty" :
null,
"disputeAction" : null,
"nettingTxnPayableStatus" : null,
"nettingTxnReceivableStatus" : null,
"useEarmarkedLimits" : null,
"jsonString" : null,
"editedFields" : null,
"allowBackDatedDisbursments" : null,
"disbursementCcy" : null,
"maxFinanceableAmount" : null,
"amtToBeFinancedinInvCcy" : null,
"isAnomalous" : null,
"isAnomalyDetected" : null,
"anomalyDescription" : null,
"tenor" : null,
"debtorName" : "ATDPSUPPLIER",
"financeVerificationStatus" : null,
"financeOrganization" : null,
"finOrgFinancedAmount" : null,
"factoringProfile" : null,
"twoFactorApp" : null,
"financiableAmount" : null,
"finProcessStatus" : null,
"accountName" : null,
"accountCurrency" : null,
"beneAddr1" : null,
"beneAddr2" : null,
"beneAddr3" : null,
"beneAddr4" : null,
"beneCountry" : null,"beneCountryName" :
null,
"beneContact" : null,
"beneEmail" : null,
"interBic" : null,
"interBank" : null,
"interAddr1" : null,
"interAddr2" : null,
"interAddr3" : null,
"interAddr4" : null,
"invoiceDisbCrdtAcc" : { "id" : "1348976581746876416",
"seqNo" : 1,
"invoiceRefNo" : "INV0451",
"invoiceMasterId" :
"1348976581746876416",
"transactionRefNo" : "004110325INV1464",
"accountType" : null,
"bank" : null,
"branch" : null,
"bic" : null,
"accountNo" : null,
"accountName" : null,
"paymentMode" : null,
"accountCurrency" : null,
"product" : null,
"role" : null,
"beneAddr1" : null,
"beneAddr2" : null,
"beneAddr3" : null,
"beneAddr4" : null,
"beneCountry" : null,
"beneContact" : null,
"beneEmail" : null,
"interBic" : null,
"interBank" : null,
"interAddr1" : null,
"interAddr2" : null,
"interAddr3" : null,
"interAddr4" : null,
"newAcctFlag" : null,
"beneCountryName" : null
}
} ],
"grantType" : "client_credentials"
}
Response:
{"data" : {
"request_identification" :
"adb1f00c-9e13-4d3c-bdc4-b665a1bc23fe"
}STATUS
To check the Status of the Registration and Financing.
SERVICE-CONSUMER = “OBSCFCM_FINANCE_DEDUPE”
SERVICE-CONSUMER-SERVICE= “STATUS”
Request:
{
"branchCode" : "004",
"audience" : "https://api.uat.securefinancing.com",
"clientId" : "77QdQGPI6aXS0aKY6bua2SgyyXIoxwjG",
"offset" : 0,
"isLoggingRequired" : false,
"limit" : "500",
"clientSecret" : "442t9wuejDJANnZBZMYNJ_KCGDCZ-7VHAbagSeq8_o5oVNJeLIVy1g7dVvhnpUhN",
"grantType" : "client_credentials",
"requestIdentification" : "85edd873-707f-48e7-af99-4229e161cf04"
}Response:
"data" :{
"links" : [ {
"href" :
"https://api.uat.eu.securefinancing.com/v1/status/85edd873-707f-48e7-af99-4229e161cf04?include-cancelled=false&include-similarity=CRITICAL_SIMILARITY&include-similarity=HIGH_SIMILARITY&limit=500&offset=0",
"rel" : "self",
"type" : "GET"
},{
"href" :
"https://api.uat.eu.securefinancing.com/v1/status/85edd873-707f-48e7-af99-4229e161cf04?include-cancelled=false&include-similarity=CRITICAL_SIMILARITY&include-similarity=HIGH_SIMILARITY&limit=500&offset=0",
"rel" : "first",
"type" : "GET"
},{
"href" : "https://api.uat.eu.securefinancing.com/v1/status/85edd873-707f-48e7-af99-4229e161cf04?include-cancelled=false&include-similarity=CRITICAL_SIMILARITY&include-similarity=HIGH_SIMILARITY&limit=500&offset=0", "rel" : "last", "type" : "GET"
} ],
"request_identification" :
"85edd873-707f-48e7-af99-4229e161cf04",
"submitting_financial_institution_identification" :
"3ac506ec-8b62-4eab-b4c3-0dead0bc9f21",
"creation_date_time" : "2025-03-11T06:05:54.789Z",
"financing_validation_data_set_details" : [ {
"pool_identification" : "004110325INV1335",
"batch_identification" : "22c2de93-f2da-4a0a-9fe0-f84303de3af5",
"batch_booking" : false,
"submitter_data_set_identification" : "INV0401",
"data_set_identification" : "bc7b0bc2-ab51-42f2-bacc-46ac36823fab",
"financing_applicant" : { "name" : "RELIANCE" },
"referred_documents" : [ { "trade_utility_service" : [ ],
"document_summary" : { "document_type" : "CINV",
"issue_date" : "2022-11-09",
"seller_identification" : { "name" : "APIAutoNonCustomer" },
"buyer_identification" : { "name" : "RELIANCE" },
"invoice_number" : "INV11MARC001",
"total_invoice_amount" : { "currency" : "USD",
"amount" : "800" },
"commercial_line_items" : [ ],
"ship_to_address_line" : [ ] },
"registered_document_identification" : "86a9c721-19fc-4934-8eda-725abfb660cb",
"trade_utility_matching" : [ ],
"trade_utility_data" : [ ],
"document_duplicate_matches" : { "exact_matches" : [ ],
"partial_matches" : [ ] } } ],
"financing_request_status" : "FNCD",
"financing_request_duplicate_report" : [ ],
"errors" : [ ]
} ]
}FINANCINGS
To mark the Invoices as Financed in the MonetaGo system.
SERVICE-CONSUMER = “OBSCFCM_FINANCE_DEDUPE”
SERVICE-CONSUMER-SERVICE= “FINANCINGS”
Request:
{
"branchCode" : "004",
"audience" : "https://api.uat.securefinancing.com",
"clientId" : "77QdQGPI6aXS0aKY6bua2SgyyXIoxwjG",
"isLoggingRequired" : false,
"clientSecret" :
"442t9wuejDJANnZBZMYNJ_KCGDCZ-7VHAbagSeq8_o5oVNJeLIVy1g7dVvhnpUhN",
"submitFinancialInstitutionId" :
"3ac506ec-8b62-4eab-b4c3-0dead0bc9f21",
"invoiceDetails" : [ {
"id" : "1348898263605436416",
"instrumentRefNo" : "INV0401",
"isFinanced" : null,
"partnerRegistrationIdentification" :
"867acbb7-4db5-4ebb-a78f-8a393693c52e",
"partnerIntrumentIdentification" :
"bc7b0bc2-ab51-42f2-bacc-46ac36823fab",
"instrumentDedupStatus" : "REGU",
"eventDateTime" : 1741673153000,
"matchingBlob" : null,
"financeOrganization" : null,
"finOrgFinancedAmount" : null,
"event" : "Registration Status",
"partnerCancellationIdentification" : null,
"partnerFinIdentification" : null,
"financeRefNo" : null,
"errors" : null,
"isPartnerIntegrationSkipped" : null,
"partnerIntegrationSkippedStage" : null,
"cancelErrors" : null
} ],
"grantType" : "client_credentials" }
Response:
"data" : {
"request_identification" : "85edd873-707f-48e7-af99-4229e161cf04"
}CANCELLATIONS
To cancel the Financing and Registration for the Invoices in the MonetaGo system.
SERVICE-CONSUMER = “OBSCFCM_FINANCE_DEDUPE”
SERVICE-CONSUMER-SERVICE= “CANCELLATIONS”
Request:
{
"branchCode" : "004",
"audience" : "https://api.uat.securefinancing.com",
"clientId" : "77QdQGPI6aXS0aKY6bua2SgyyXIoxwjG",
"isLoggingRequired" : false,
"cancellationReason" : "EXNB",
"clientSecret" :
"442t9wuejDJANnZBZMYNJ_KCGDCZ-7VHAbagSeq8_o5oVNJeLIVy1g7dVvhnpUhN",
"submitFinancialInstitutionId" :
"3ac506ec-8b62-4eab-b4c3-0dead0bc9f21",
"invoiceDetails" : [ {
"id" : "1348705817760096256",
"instrumentRefNo" : "INV0323",
"isFinanced" : null,
"partnerRegistrationIdentification" :
"b44422a0-fa40-4098-a45b-c58934020586",
"partnerIntrumentIdentification" :
"2ece6a7c-4c65-4c4b-9689-ab72d5815ebf",
"instrumentDedupStatus" : "FNCD",
"eventDateTime" : 1741626955000,
"matchingBlob" : null,
"financeOrganization" : null,
"finOrgFinancedAmount" : null,
"event" : "Mark Finance Status",
"partnerCancellationIdentification" : null,
"partnerFinIdentification" :
"ec7875f5-4ccb-4e62-8399-6104583837ea",
"financeRefNo" : "004091122AM06767",
"errors" : null,
"isPartnerIntegrationSkipped" : null,
"partnerIntegrationSkippedStage" : null,
"cancelErrors" : null
} ],
"grantType" : "client_credentials"
}Response:
"data" : {
"cancellation_identification" :
"9c5423a4-71e7-456e-be34-a284f4355828"
}CANCELLATIONS STATUS
To check the status of the cancellation.
SERVICE-CONSUMER = “OBSCFCM_FINANCE_DEDUPE”
SERVICE-CONSUMER-SERVICE= “CANCELLATIONSSTATUS”
Request:
{
"branchCode" : "004",
"cancellationIdentification" : "9c5423a4-71e7-456e-be34-a284f4355828",
"audience" : "https://api.uat.securefinancing.com",
"clientId" : "77QdQGPI6aXS0aKY6bua2SgyyXIoxwjG",
"isLoggingRequired" : false,
"clientSecret" : "442t9wuejDJANnZBZMYNJ_KCGDCZ-7VHAbagSeq8_o5oVNJeLIVy1g7dVvhnpUhN",
"grantType" : "client_credentials" }Response:
"data" : {
"submitting_financial_institution_identification" :
"3ac506ec-8b62-4eab-b4c3-0dead0bc9f21",
"cancellation_identification" : "f8404575-2f39-4b81-a22a-c3c1b4a47e13",
"cancellation_status_batch" : [
{
"request_identification" : "f8404575-2f39-4b81-a22a-c3c1b4a47e13",
"pool_identification" : "004160125INV195238",
"batch_identification" : "d5e120e8-8ecb-497b-ac17-ca3308791560",
"data_set_identification" : "0f8be134-c63f-4507-8a81-0c3f313184d0",
"submitter_data_set_identification" : "INV0141",
"cancellation_reason" : "EXNB",
"cancellation_status" : "REJT"
} ],
"error" : [ {
"cancellation_status" : "REJT"
} ]
}Parent topic: Outbound API configuration in Oracle Banking Routing Hub