Cash Management - BankStatementsProcessingForCloud - Automation

Summary

Trying to automate BankStatementsProcessingForCloud

Content

Hello,

 

We are trying to automate the bank statement upload into Oracle Cloud. Our business is getting bank statements in MT940 format for multiple bank accounts (approx 50-70 file per day) and it is getting tougher to handle file manually (we need to first "File Import and Export" & "Load and Import Bank Statement")

 

After my research, following is the approach:

1. uploadFileToUcm – to upload the file into Oracle Cloud

POST https://<servername>:443/fscmRestApi/resources/11.13.18.05/erpintegrations

Payload:
{
"OperationName":"uploadFileToUCM",
"DocumentContent":"<BASE64 CONTENT>",
"DocumentAccount":"fin/cashManagement/import",
"ContentType":"txt",
"FileName":"BKSTMT_1_202002201300_MT940_FILE.txt",
"DocumentId":null
}

Response: