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:

OIC - Download file from ucm using webservice | ErpIntegrationService

Usecase: Here I will show you how to get the file from ucm using ErpIntegrationService webservice as follows:

Case1:

1. First get document id by file prefix (doc title) 
2. Second get document by document id , fetched from 1st step.

Case2:

1. Get the document by file prefix(doc title) directly.

Detailed steps with screenshots:

Create a soap connection with

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

Case1 : Integration flow:

Call soap adapter to get doc id by file prefix

Call soap adaptet to get document by document id.

Aftet testing, got the document in base64 coded. To read it, we have to decode it.

Case2 : Integration flow

Call soap to get document by file prefix

Testing:

OIC - Can file adapter and ftp adapter support high availability mode using connectivity agent

***The File Adapter and FTP Adapter are not supported in high availability environments. When using the File Adapter or FTP Adapter and some groups have multiple instances, use a dedicated agent group (with one agent only).

Reference:

https://docs.oracle.com/en/cloud/paas/integration-cloud/integrations-user/use-agent-high-availability-environments.html

OIC - Upload file to UCM using GenericSoapPort web service

Usecase: We will create a CSV file into stage and upload the base64 encoded file to UCM using GenericSoapPort webservice.

Request Payload format to upload to UCM:

<ns0:GenericRequest webKey="CS">

<ns0:Service  IdcService="CHECKIN_NEW">

<ns0:Document>

<ns0:Field name="dDocTitle">test.csv</ns0:Field>

<ns0:Field name="dDocType">Document</ns0:Field>

<ns0:Field name="dSecurityGroup">FAFusionImportExport</ns0:Field>

<ns0:Field name="dDocAccount">fin$/payables$/importExport$</ns0:Field>

<ns0:File href="test.csv" name="primaryFile">

<ns0:Contents>TmFtZSxJRCxBZ2UsRGVwdAp0ZXN0LDIsMjMsT1NQCg=</ns0:Contents>

</ns0:File>

</ns0:Document>

</ns0:Service>

</ns0:GenericRequest>

Note: we can also add dUser, dDocAuthor and other fields as required.

Detailed steps with Screenshots:

Create a soap connection with the below wsdl :

https://<erp_instance>:443/idcws/GenericSoapPort?wsdl

Integration flow:

Write a CSV file:

Call the SOAP adpater and configure:

Map the required details:

Go to UCM server and check the file:

https://<erp_instance>/cs

We can also check the file from below navigation:

Login erp instance >> tools >>File import and export >> search with file name and account details: