Thursday, July 6, 2023

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


Integration flow:

Create a csv file into stage:

Call soap service to upload file:

Map the required fields:

No comments:

Post a Comment

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...