To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Integration
Discussion List
-
Is that TRUNCATE query not supported?Summary Is that TRUNCATE query not supported?Content Hi, When I am using the TRUNCATE query in Run on SQL Statement, OIC is showing SQL statement syntax is not supported…
-
Unable to create a Connection using Oracle Database AdapterContent As I am trying to create a connection using the Oracle Database Adapter, by filling in all the credentials such as public IP, port number, username and password …
-
Error handling while subscribing to business eventsContent Hi We are working on a new integration (OIC) where we will be subscribing to a business event in EBS (On-Prem) and sending the information to Procurement cloud. …
-
Oracle Streams - Understanding message limit on getMessagesContent Hi All, I'm using Oracle Stream as a way of passing messages between applications. I'm doing some discovery work initially to understand the streams API. I have …
-
Version controllingSummary Options for Version control for OICContent Hi Team, What is best for version control for OIC code. Can we have version internal to OCI or we should use third par…
-
To extract values from the Activity Stream inside Oracle IntegrationContent As you can see I am testing the API without any request parameters. So I want to extract the values for X in the Activity Stream . Are there any provisions to ex…
-
Check the file sizeSummary Can you check file size in ftp server ?Content Hi, When trying to send email notification in OIC, it fails sending email due to large size. OIC can not send file…
-
Oracle Integration Customer Update Webcast February 16th 2021Summary Oracle Integration Update & February Release & Success Story & Oracle Insight February 23rd 2021Content Attend this webcast to accelerate your digital transforma…
-
How to Format the Cells of the File used to upload in the Stage File Action.Summary How to Format the Cells of the File used to upload in the Stage File Action.Content HI, For Generating daily report, using Stage File Action. Uploaded a new Deli…
-
Wanted to read monthly data from VBCS BO using REST adapter inside App driven IntegrationSummary Wanted to read large data for whole month using REST adapter inside the App driven Integration.Content Hi, We have a report page in our project in which we are d…
-
Document size limit for Oracle Procurement Cloud's Purchase Order SOAP Web ServiceContent SOAP Web Services for Oracle Procurement document states that Purchase Order Web Service can handle up to 200 lines for call and provides three alternatives for …
-
Eloqua Integration issuesSummary Eloqua integrationContent Hi We are trying to do an Eloqua integration for sending newsletter emails with sending just the email address in the request to Eloqua…
-
OIC endpoint access policiesSummary OIC endpoint access policiesContent Hi All I am trying to understand how I can assign user policies for accessing the OIC integration endpoints. I have created a…
-
Stage File read records based on a filter ?Summary Wondering if i can read a few records from all records in a file in stage file using a filterContent Hey There, suppose I have a file with 10 columns and 100 row…
-
How to invoke OIC Integration through the fusion Job ProcessContent Hello, We have a requirement to invoke the Rest API Based OIC Integration through the Fusion Job Process. Is their a way where we can achieve this. Thanks, Sande…
-
Insert base64 string to SQL server tableSummary Insert base64 string to SQL server tableContent Hi, I am using OIC to expose rest service. the json input contains base64 string and I am trying to insert it to …
-
OIC to Include SFTP Server?Summary Will OIC be releasing an included SFTP server?Content I've heard talk that OIC will include a local SFTP server in a future release? Can anyone confirm or deny t…
-
Integrate a soap xml request in REST adaptorSummary SOAP xml request in REST adaptorContent Hi all I am facing a unique problem where I want to integrate FEDEX Address Validation API with integration cloud. But I …
-
Convert .xls file to .dat file and upload to HCM cloudSummary I am new to OIC and I have a requirement to get the .xls file from third party and convert it to .dat file format and zip the file as per HDL standard format and…
-
Reading a DB column containing a JSON string and passing it to a third party APIContent Hi everyone, we are storing a JSON string in a DB column, and we would like to parse it in OIC and sending it to a third party API using the Rest Adapter. How ca…
-
Custom soap HeaderSummary Custom soap Header for OIC SOAP RequestContent We have an integration to make soap call to an external system from OIC. This SOAP request has a custom header in …
-
Increment variable inside loopContent Hi, Assume, in my source we have 5 records. Our target system expect the input request like below. Our Expectation is we need to increment the sequence (seq) val…
-
REST API for Oracle Financials Cloud : Perform Batch Actions IssueContent Hi All, I am trying to use the perform Batch Actions feature for REST API for Oracle Financials Cloud from OIC. However, I am always getting the same error when …
-
How to data stitch variable append multi valuesContent Hi, I try to append data in data stitch variable but its show error message. Thanks Prakash J
-
Mapping an array to the specific fieldsContent Hello! I'm having some issues with a mapping on an integration. This integration will receive an array of properties like this bellow: [{ id : 1, value: a }, { i…
-
How to get inside scope values or connection response in outsideContent Hi, I try to get inside scope values is outside scope integration. Thanks Prakash J
-
HCM Workers REST APIs not returning all the managers of an WorkerSummary HCM Workers REST APIs not returning all the managers of an WorkerContent Oracle HCM Rest API link to fetch all managers of the worker…
-
VBCS : Editable Table Demo not working in New Runtime.Summary Demo runs with old runtime but when I create from scratch in VBCS Version: 20.10.1 it stopped working.Content Dear All, I tried creating an Editable table follow…
-
OIC integration with Oracle Fusion Cloud - Customer (insert/update) ExcerciseContent Hello There, I would like to know if there is an excercise that I can practice, on how to do a simple integration of OIC with: 1. Oracle Fusion Cloud (Customer: …
-
User do not have permission to run the reportContent Hi Everyone, I am using a Oracle SaaS user in Integration cloud to run the report, When I fire the request its throwing the error saying user: **** does not have…