2.2.6.2 Consumer Services - Oracle Banking Electronic Data Exchange
This topic describes about the consumer services required for Oracle Banking Electronic Data Exchange Implementation.
The following callback API is configured for Oracle Banking Electronic Data Exchange Implementation using Oracle Banking Routing Hub
Figure 2-22 Consumer Services - OBVAM_OBEDX
Figure 2-23 Edit Transformation - OBVAM_OBEDX
HandoffResponse
Request:
{
"fileRefId": 110634,
"internalRefId": null,
"workflowInstanceId": "",
"fileStatus": "",
"cacheVersion": 0,
"fileOriginalName": "",
"fileModifiedName": "",
"fileSize": 692,
"formatName": null,
"createdBy": null,
"createdDate": 1651721400000,
"modifiedBy": null,
"modifiedDate": 1651721405000,
"transactionId": "",
"transactionName": null,
"transactionModNo": 1,
"formatId": "",
"formatModNo": 1,
"channelId": "",
"channelModNo": 1,
"corporateId": "",
"corporateModNo": 1,
"corporateRef": null,
"totalRecords": 2,
"successRecords": 0,
"failedRecords": 0,
"totalAmount": null,
"totalAmountCurrency": null,
"messageId": null,
"initiatingPartyName": null,
"initiatingPartyId": "",
"initiatingPartyCD": null,
"initiatingPartyAddress": {},
"groupStatus": null,
"groupStatusReasonCode": null,
"noOfHandoff": null,
"handoffId": null,
"corelationLevel": null,
"recordPersist": false,
"chunkSize": 2,
"chunkIndex": 1,
"totalChunks": 1,
"retryCount": 0,
"retryForChunk": [],
"fieldData": {
"handoffId": null,
"initiatingPartyName": null
},
"recordList": [{
"recordId": 971614727779409900,
"fileRefId": 110634,
"modifiedBy": "",
"modifiedDate": 1523052010000,
"txnStatus": "",
"statusCodes": "",
"transactionId": "",
"transactionModNo": 1,
"createdDate": null,
"createdBy": null,
"fxRate": null,
"convertedCurrency": null,
"convertedAmount": null,
"fieldData": {
"odStartDate": "",
"virtualAccountName": "",
"debitTxnsAllowed": "",
"fixedAmtFromPool": null,
"odEndDate": "",
"transferInVirAccNo": null,
"accountPurpose": "",
"action": "new",
"addressLine1": "",
"buildingNumber": "",
"addressLine2": "",
"addressLine3": "",
"addressLine4": "",
"pincode": "",
"townName": "",
"overdraftSanctionAmount": null,
"defaultAccCcy": "",
"postBox": "",
"virtualParentAcc": null,
"realCustomerNo": "",
"branchCode": "",
"virtualEntityId": "",
"transferOutVirAccNo": null,
"buildingName": "",
"structureCode": null,
"postCode": "",
"virtualAccountNo": null,
"interestCalcReq": "N",
"realAccountBrn": null,
"ibanAccNo": null,
"countrySubDivision": "",
"realAccountCcy": null,
"accountFrozen": "N",
"subDepartment": "",
"realAccountNo": null,
"streetName": "",
"ibanRequired": "",
"countryCode": "",
"balChkForDebits": "",
"department": "",
"floor": "",
"virtualAccProduct": "",
"townLocationName": "",
"districtName": "",
"overdraftAllowed": "",
"creditTxnsAllowed": "",
"strrCountry": "",
"room": "",
"realAccLinkage": "",
"remarks": "",
"balAvailabilityOptions": ""
},
"exceptionList": [{
"exceptionCode": "",
"exceptionArgs": "",
"lineNo": 1,
"CreatedDate": null
}]
}],
"exceptionList": []
}
Response:
{
"body": {
"messages": {
"status": "SUCCESS",
"codes": [{
"information": true,
"override": false,
"error": false,
"overrideAuthLevelsReqd": 0,
"desc": "Record Created successfully",
"code": "EDX-HCB-000",
"language": "ENG",
"type": "I"
}],
"httpStatusCode": "OK"
},
"data": {
"links": []
}
}
}
ParseResponse
Request:
{
"fileRefId": 110635,
"internalRefId": null,
"workflowInstanceId": "",
"fileStatus": "",
"cacheVersion": 0,
"fileOriginalName": "",
"fileModifiedName": "",
"fileSize": 692,
"formatName": "CSV",
"createdBy": null,
"createdDate": 1651721490130,
"modifiedBy": null,
"modifiedDate": null,
"transactionId": "",
"transactionName": "Open Virtual Account",
"transactionModNo": 1,
"formatId": "",
"formatModNo": 1,
"channelId": "",
"channelModNo": 1,
"corporateId": "",
"corporateModNo": 1,
"corporateRef": null,
"totalRecords": 2,
"successRecords": 0,
"failedRecords": 0,
"totalAmount": null,
"totalAmountCurrency": null,
"messageId": null,
"initiatingPartyName": null,
"initiatingPartyId": "",
"initiatingPartyCD": null,
"initiatingPartyAddress": {},
"groupStatus": null,
"groupStatusReasonCode": null,
"noOfHandoff": null,
"handoffId": null,
"corelationLevel": null,
"recordPersist": false,
"chunkSize": 2,
"chunkIndex": 1,
"totalChunks": 1,
"retryCount": 0,
"retryForChunk": [
0
],
"fieldData": {
"handoffId": null,
"initiatingPartyName": null
},
"recordList": [{
"recordId": 971615103983312900,
"fileRefId": 110635,
"modifiedBy": null,
"modifiedDate": null,
"txnStatus": "",
"statusCodes": null,
"transactionId": "",
"transactionModNo": 1,
"createdDate": null,
"createdBy": "",
"fxRate": null,
"convertedCurrency": null,
"convertedAmount": null,
"fieldData": {
"odStartDate": "",
"accLiqdAllowed": "",
"virtualAccountName": "",
"debitTxnsAllowed": "Y",
"fixedAmtFromPool": "",
"odEndDate": "1990-01-01",
"transferInVirAccNo": "",
"accountPurpose": "",
"action": "new",
"addressLine1": "",
"buildingNumber": "88",
"addressLine2": "",
"addressLine3": "",
"addressLine4": "",
"pincode": "",
"townName": "",
"defaultAccCcy": "",
"postBox": "",
"virtualParentAcc": "",
"realCustomerNo": "",
"branchCode": "",
"virtualEntityId": "",
"transferOutVirAccNo": "",
"buildingName": "",
"structureCode": "",
"postCode": "",
"virtualAccountNo": "",
"interestCalcReq": "",
"realAccountBrn": "",
"ibanAccNo": "",
"countrySubDivision": "",
"realAccountCcy": "",
"accountFrozen": "",
"subDepartment": "",
"realAccountNo": "",
"streetName": "",
"ibanRequired": "",
"countryCode": "",
"balChkForDebits": "",
"fixedAmount": "",
"department": "",
"floor": "8",
"virtualAccProduct": "",
"townLocationName": "",
"districtName": "",
"overdraftAllowed": "",
"creditTxnsAllowed": "",
"strrCountry": "",
"room": "",
"realAccLinkage": "",
"remarks": ",
"balAvailabilityOptions": ""
},
"exceptionList": [{
"exceptionCode": "",
"exceptionArgs": "",
"lineNo": 1,
"CreatedDate": 1651721492536
}]
}],
"exceptionList": []
}
Response:
{
"body": {
"messages": {
"status": "SUCCESS",
"codes": [{
"information": true,
"override": false,
"error": false,
"overrideAuthLevelsReqd": 0,
"desc": "Record Created successfully",
"code": "EDX-PCB-000",
"language": "ENG",
"type": "I"
}],
"httpStatusCode": "OK"
},
"data": {
"links": []
}
}
}
postFileDetails
Request:
{
"ackFileDTO":
[
{
"index": 1,
"type": "TEXT",
"content": "{\"fileRefId\":16652,\"ackfileRefId\":16652,\"ackfileName\":\"ACME_CSV_Open
Virtual Account_20221010000004\",\"ackfileChannelName\":\"AutoCorpOutgoing\",
\"ackResponseIdentifier\":\"RESPONSE_FILE\",\"ackfileStatus\":\"EDX-COF-000\",
\"chunkSize\":0,\"chunkIndex\":0,\"totalChunks\":0,\"totalRecords\":1,
\"recordList\":[{\"recordId\":1033332842200104960,\"lineNo\":null,
\"status\":\"EDX-COR-000\",\"exceptionList\":[]}]}"
}
],
"file":
[
{
"fileName": "ACME_CSV_Open Virtual Account_20221010000004.csv",
"file": "file_0",
"index": 0,
"type": "FILE"
}
]
}Response:
{
"headers": {},
"body": {
"data": {
"messages": {
"status": "SUCCESS",
"codes": [
{
"information": false,
"override": false,
"error": false,
"code": "EDX-ADS-009"
}
]
}
},
"messages": {
"keyId": null,
"status": "SUCCESS",
"codes": [],
"requestId": null,
"httpStatusCode": "OK",
"overrideAuthLevelsReqd": null
}
}
}
Parent topic: Oracle Banking Host to Host Implementation