6.4 Consumer Services - Oracle Banking Cash Management

This topic describes about the consumer services required for Oracle Banking Cash Management Implementation.

The below endpoints must be configured under Consumer Services in Oracle Banking Routing Hub:
  1. CashflowTxnUpdate
  2. CashflowTxnRead

Figure 6-4 Consumer Services - Cash Management



CashflowTxnUpdate

This API enables the user to provide accurate forecasts of guaranteed cashflows.

SERVICE-CONSUMER = “OBSCFCM_OBCM”

SERVICE-CONSUMER-SERVICE= “CashflowTxnUpdate”

Request:

{branchCode=004, requestList=[class InvoiceModel {
    srcAppCd: HOST
    id: 1088353446166745088
    seqNo: 1
    invoiceId: 2022070600000000000000000000000000001072
    acceptanceAmount: 10000
    amount: 10000
    buyerId: 000380
    buyerName: Carrefour
    buyerDivCode: null
    buyerDivName: null
    currency: USD
    isDisputed: null
    discrepancyCode: null
    disputeResolveRemarks: null
    fileName: null
    fileRef: null
    filler1: null
    filler2: null
    filler3: null
    filler4: null
    filler5: null
    filler6: null
    filler7: null
    filler8: null
    filler9: null
    filler10: null
    financeAmount: 0
    financePercentage: 0
    indicator: I
    invoiceDate: 2022-07-06
    invoiceDueDate: 2023-03-23
    invoiceNumber: INVCASH01
    invoiceProcessStatus: SUCCESS
    invoiceRefNo: INV1466
    invoiceStatus: ACCEPTED
    invAcceptanceDate: 2022-07-06
    maxFinancePercentage: null
    paidAmount: 0
    paymentStatus: UNPAID
    preAccepted: Y
    poNumber: null
    programCode: null
    programName: null
    reasonCode: null
    remarks: null
    supplierId: 000381
    supplierName: Danone
    supplierDivCode: null
    supplierDivName: null
    taxAmount: 0
    totalInvoiceAmount: 10000
    paymentTerms: null
    shipmentDate: null
    outstandingAmount: 10000
    discountAllowed: Y
    discountPercentage: 0
    discountAmount: 0
    taxPercentage: 0
    purchaseOrderDate: null
    staleStatus: N
    divisionCode: null
    shipmentAddress: null
    shipmentCountry: null
    shipmentNo: null
    reasonForExport: null
    termsOfSale: null
    countryOfOrigin: null
    miscCharge1: null
    miscCharge1Amount: 0
    miscCharge1Desc: null
    miscCharge2: null
    miscCharge2Amount: 0
    miscCharge2Desc: null
    netInvoiceAmount: 10000
    financeableAmount: null
    finTxnStatus: null
    transactionRefNo: 004230323INV2642
    relationCode: REL701
    supplierCode: null
    buyerCode: null
    shipmentRefNo: null
    repayAccountNo: null
    bank: null
    branch: null
    routingCode: null
    isAutoAuth: null
    reasonErrorCode: null
    isApproved: null
    invoiceCommodityGridList: []
    finEligibilityAmt: null
    reconTxnStatus: null
    reasonForShipment: null
    virtualAcFlag: N
    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: null
    oldAcceptanceAmount: null
    oldFinanceAmount: null
    amountToBeFinanced: null
    oldInvoiceDueDate: null
    oldDisputeAmount: null
    sourceTxnId: HOST004230323INV2642
    adjustmentReason: null
    linkInvoiceNumber: 
    paymentDueDate: 2023-03-23
    isPUA: null
    isIndirectPayment: null
    paymentParty: null
    importFactorId: null
    importFactorName: null
    insuranceCoId: null
    insuranceCoName: null
    paymentMode: null
    reconPmtAmount: 0
    reconPmtAmountCcy: null
    varianceAmount: null
    linkedInvoiceList: null
    currentStageCode: null
    currentStageName: null
    invoiceOffer: null
    shipmentCity: null
    shipmentZipCode: null
    shipmentPhoneNumber: null
    shipmentTaxId: null
    financeStatus: null
    invoiceOfferList: null
    feedSerialNo: null
    expiresOn: null
    fundingReqDate: null
    newFundingReqDate: null
    oldExpiryDate: null
    bunchIdentifier: null
    discountType: null
    invoiceOfferTenorParameterList: null
    invoiceValueDate: null
    discount1Days: null
    discount2Days: null
    discount1Perc: null
    discount2Perc: null
    paymentCondition: null
    exportFactorId: null
    validateForOverdue: null
    isOverdueReceivable: null
    shipSeqNo: 1
    finSeqNo: 1
    paySeqNo: 1
    channel: HOST
    isNettingFlag: null
    tmDrCrNoteLinkInvoiceList: []
    corporateId: 000380
}], from=INVOICE, userId=AUTOUSER20}

Response:

{"messages": {
            "keyId": null,
            "status": "SUCCESS",
            "codes": [],
            "requestId": null,
            "httpStatusCode": "OK",
            "overrideAuthLevelsReqd": null
        }
    }

CashflowTxnRead

This API enables the user to provide accurate forecasts of guaranteed cashflows.

SERVICE-CONSUMER = “OBSCFCM_OBCM”

SERVICE-CONSUMER-SERVICE= “CashflowTxnRead”

Request
{branchCode=004, externalTransactionRefNo=INV1312225, partyId=000381, userId=ARABINDA}
Response:
{	
	"cashflowResponseDetails" : {
		"externalTransactionRefNo" : "INFRF001",
		"cashflowType":"",
		"currency":"",
		"amount":1000,
		"amount":1000,
		"partyId":"000381",
    	"expecDate":,
 	    "actualDate":,
		"cashFlowCode":,
		"cashflowDescription":"",
		"narration":"",
		"customerRefNo":"000381",
		"reconStatus":"",	
	"counterpartyId":"000381",		
"counterpartyName":"CUST 1",	
	"bankAccountNumber":"1001",		
"virtualAcctNo":"1001"
	} 
}