OIC - Download file from UCM using Oracle ERP Cloud adapter | ErpIntegrationService

Usecase: Here I will show you how to get the file from ucm using Oracle Cloud ERP adapter ErpIntegrationService 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 an Oracle ERP cloud adapter connection

Integration flow:

Write a file to stage:

Create a csv file into stage:

Call Oracle ERP cloud adapter to download file from UCM:

Case1: 

Case2:

OIC - Upload file to UCM using Oracle Cloud ERP adapter | ErpIntegrationService

Usecase: Here, I will show you how to upload files to UCM using Oracle ERP Cloud adapter.

Case1:

• Using Send Files to ERP Cloud with details:
• docTitle : filename
• doctype : Document
• securityGroup : FAFusionImportExport
• docAccount : fin$/payables$/import$
• fileReference : stage file reference

Case2:

• Using Query, Create, update or delete information ErpintegrationService and operation: uploadFileToUcm with details:
• Content : file reference or base64 encoded
• Filename
• ContentType: filetype(csv, document or zip)
• DocumentTitle: filename
• DocumentSecurityGroup: FAFusionImportExport
• DocumentAccount : fin$/payables$/import$

Detailed steps with Screenshots:

Create an Oracle ERP cloud adapter connection

Integration flow:

Write a file to stage:

Create a csv file into stage:

Call Oracle ERP cloud adapter to upload file:

Case1: Send Files to ERP Cloud option

Case2: Query, Create , update or delete information option.

OIC -Upload file to UCM using Rest service

Usecase: Here I will show you how to create a csv file into stage and upload the file to UCM using rest service.

Rest service URI used:

/fscmRestApi/resources/11.13.18.05/erpintegrations

Sample request payload:

{

  "OperationName":"uploadFileToUCM",

  "DocumentContent":"UEsDBBQAAAAIABCInEgIHJSKCgAAAAgAAAAIAAAAdGVzdC50eHRzTEpWCEktLgEAUEsBAh8AFAAAAAgAEIicSAgclIoKAAAACAAAAAgAJAAAAAAAAAAgAAAAAAAAAHRlc3QudHh0CgAgAAAAAAABABgAW4FRYEGh0QEBIE9gQaHRAckeCWBBodEBUEsFBgAAAAABAAEAWgAAADAAAAAAAA==",

  "DocumentAccount":"fin$/payables$/import$",

  "ContentType":"zip",

  "FileName":"Test.zip",

  "DocumentId":null

}

About Request parameters:

• OperationName: uploadFileToUCM
• Document content: base64 encoded file. Here, I have used oraext:encodeReferenceToBase64() to encode from file reference to base64.
• DocumentAccount: "fin$/payables$/import$" >> anyone you need
• Content type: Document or zip
• Filename : give the file name which to be uploaded to UCM

Detailed steps with screenshots:

Create a rest connection 

Integration flow:

Create a csv file into stage:

Call rest service to upload file:

References:

https://docs.oracle.com/en/cloud/saas/financials/23b/farfa/op-erpintegrations-post.html

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: