Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Cash Management - BankStatementsProcessingForCloud - Automation

edited Feb 27, 2020 6:16PM in ERP Integrations 8 comments

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!