Cash Management - BankStatementsProcessingForCloud - Automation
Summary
Trying to automate BankStatementsProcessingForCloudContent
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: