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:

OIC - Download file from UCM using SOAP webservice | GenericSoapPort webservice

Usecase: Here, we will show you how to download files from UCM using GenericSoapPort  SOAP web service. 

• Get the document id with dDocTitle or file title.
• Get the file based on the fetched document id.
• Write the file content to stage.
• Read the file content.
• Delete the file from UCM based on fetched documment id.

Soap webservice details:

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

Request payloads used:

Get the document id with dDocTitle:

<ns0:GenericRequest webKey="CS">

<ns0:Service  IdcService="GET_SEARCH_RESULTS">

<ns0:Document>

<ns0:Field name="QueryText">dDocTitle &lt;starts> `testUCMDownload`</ns0:Field>

</ns0:Document>

</ns0:Service>

</ns0:GenericRequest>

Get file with fetched document id:

<ns0:GenericRequest webKey="CS">

<ns0:Service  IdcService="GET_FILE">

<ns0:Document>

<ns0:Field name="dID">4419562</ns0:Field>

</ns0:Document>

</ns0:Service>

</ns0:GenericRequest>

DELETE the file from UCM:

<ns0:GenericRequest webKey="CS">

<ns0:Service  IdcService="DELETE_DOC">

<ns0:Document>

<ns0:Field name="dID">4419562</ns0:Field>

</ns0:Document>

</ns0:Service>

</ns0:GenericRequest>

Note: instead of dDocTitle , we can also use dDocName which is the UCM content ID.

dDocName &lt;substring> `UCMFA03374721`

Implementation Steps with screenshots:

Create SOAP connection:

Integration flow:

Assign the QueryText:

varString : "testUCMDownload"

varQueryText: concat("dDocTitle <starts> `",$varString,"`")

Call webservice to get doc id based on dDocTitle Query text.

Call webservice to get file based on fetched doc id.

Write the file to stage.

Read the file content.

Call webservice to delete the file from UCM based on fetched doc id:

Refererence:

https://fusiongoeasy.com/post/download-data-from-ucm-oracle-fusion

OIC - Upload file to UCM | Download file from UCM

We can upload and download the files to/ from UCM using the following services:

1. Download file from UCM using GenericSoapPort webservice
2. Download file from UCM using ErpIntegrationService webservice
3. Download file from UCM using ERP cloud adapter and ErpIntegration Service.
4. Using rest services

To access content server:

https://<erp_pod_instane>:443/cs

Case1: To upload & download file to/from UCM using GenericSoapPort webservice: follow my below blogs:

Download From UCM

https://soalicious.blogspot.com/2023/06/oic-download-file-from-ucm-using.html

Upload file to UCM:

https://soalicious.blogspot.com/2023/06/oic-upload-file-to-ucm-using.html

Case2: To upload and download file to/from UCM using ErpIntegrationService webservice:

Download from UCM:

https://soalicious.blogspot.com/2023/07/oic-download-file-from-ucm-using.html

Upload file to UCM:

https://soalicious.blogspot.com/2023/07/oic-uoload-file-to-ucm-using-webservice.html

Case3: To upload and download file to/from UCM using Oracle Cloud ERP Adapter:

Upload file to UCM:

https://soalicious.blogspot.com/2023/07/oic-upload-file-to-ucm-using-oracle.html

Download file from UCM:

https://soalicious.blogspot.com/2023/07/oic-download-file-from-ucm-using-oracle.html

Case4: To upload and download file to/from UCM using Rest Api:

Upload file to UCM:

https://soalicious.blogspot.com/2023/07/oic-upload-file-to-ucm-using-rest.html

Download file from UCM:

TBD

OIC - While reading or writting a file from/to stage, getting translation to native failed. Element not completed

Usecase: Suppose we are reading or writting a file from/into a stage and getting the below error:

Translation Failure

Translation to native failed. Element not completed : 'Employee'.

The data does not conform to the NXSD schema. Please correct the problem.

Solution:

This error occured when we are reading /wrtting the file from/to stage, most cases we are not adding any header field names and later when we try to read/write it, we are mentioning the USE FIRST ROW AS COLUMN HEADERS AS CHECKED which was expecting header field names in the file.

1.  Just uncheck this property - USE FIRST ROW AS COLUMN HEADERS and it will work.
2.  Or add header field names explitcitly in the file.