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:

  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:








No comments:

Post a Comment

Featured Post

OIC - how can I use XSLT functions to remove leading zeros from numeric and alphanumeric fields?

To remove leading zeros from an numeric field in Oracle Integration Cloud (OIC) using XSLT, you can Use number() Function The number() funct...