soalicious

Friday, July 7, 2023

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:

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

Case2:

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.

Thursday, July 6, 2023

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