OIC - Upload file to UCM using webservice | ErpIntegrationService

Usecase: Here I will show you how to create a csv file into stage and upload the file to UCM using ErpIntegrationService webservice as follows:

1. Call uploadFileToUcm operation and update the following in the mapping:
1. Document content: base64 encoded file. Here, I have used oraext:encodeReferenceToBase64() to encode from file reference to base64.
2. Filename : give the file name which to be uploaded to ucm
3. Content type: file type(csv, Document or zip)
4. DocumentTitle: filename
5. DocumentSecurityGroup: FAFusionImportExport
6. DocumentAccount: "fin$/payables$/import$" >> anyone you need

Detailed steps with screenshots:

Create a soap connection with

https://<erp_instance>/fscmService/ErpIntegrationService?wsdl

Integration flow:

Create a csv file into stage:

Call soap service to upload file:

Map the required fields: