Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Cash Management - BankStatementsProcessingForCloud - Automation — Cloud Customer Connect
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

Accepted answer
50
Views
8
Comments
edited Feb 27, 2020 6:16PM in Integrations and Extensions 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!