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. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Integration
Discussion List
-
Is there a way to get the time for the previous run of an integration in ICS?Summary Is there a way to get the time for the previous run of an integration in ICS?Content Hi We are looking at doing a batch mode integration using ICS. For this, whe… -
ERP API Update Instalments - 404 ErrorContent Hi All, I am trying to use the Rest call in the below link to update a field for an invoice. https://docs.oracle.com/en/cloud/saas/financials/21b/farfa/op-invoic…
-
Splitting a field with comma separated values in OICSummary Splitting a field with comma separated values in OICContent Hi All, I have the below problem. I have a field as below which I read from a table Entity_List : "A"…
-
Convert XML to JsonSummary Convert XML to JsonContent Hi All, I have requirement to convert XML output as Json, Steps I have followed 1) Create Rest Service Connection which will work as s…
-
How to create a payload within OICContent Hello, We are reading a bunch of records from third party using REST adapter GET. Basically, we get a collection in ITEMS array. We want to insert these records …User_2025-02-11-17-16-53-286 119 views 5 comments 0 points Most recent by User_2025-02-11-17-16-53-286 -
CSF Key nullContent Hi, Created one integration using ERP adapter and used Project Status Event. Project creation event is not triggered. When I check the list of subscriptions resp… -
Tracing logsSummary Logs in Tracing not showing after 24 hoursContent Hi Team, We have many integrations in OIC and tracing/payload enabled however the tracing for this integrations…
-
OIC Assertion - Regression catchingSummary How does OIC Assertion help capture Regression errorsContent Hi , From past few days, i have done quite a bit of reading on OIC Assertions and tried implementing…
-
OIC SFTP Connection ErrorSummary We are facing an issue with an SFTP connection and need some help if anyone has faced this issue before.Content Hi All, We have an SFTP connection in OIC which w…
-
Unable to read all the 2000 records using Stage Read File SegmentsSummary Unable to read all the 2000 records using Stage Read File SegmentsContent Hi, We have retrieved 2000 rows from BIP, then we are reading those records via Stage F…
-
Configure Oracle Storage Service in OICSummary Configure Oracle Storage Service in OICContent Hi, I created Oracle Storage Service and I can upload objects fine. Anyone knows how to configure it in OIC I don'… -
Create Multiple Supplier using REST adapter failsContent Hello Expert - I am using OIC to create multiple suppliers ( 2 suppliers payload ) In ERP using REST adapter. It fails. But, if I send only one supplier payload …User_2025-02-05-07-07-46-403 34 views 12 comments 0 points Most recent by User_2025-02-05-07-07-46-403
-
Convert Comma Separated into OR delimiterSummary Convert Comma Separated into OR delimiterContent Hi, I am currently doing a logic on changing the data format from: "listOfAccountNumbers" : "0000001, 000002, 00…
-
Using lookup-xml in integrationsContent Hi, I've been trying to implement a solution which needs to join data from two different files. File A contains business data and File B(xml) contains reference …
-
How to lookup a value in one xml based upon some key in another xml in ICSSummary looking for example to use lookup-xml functionContent Hi ICS community, We would like to lookup a value from one xml (response received from a REST call) based u…
-
OIC - Create a "fault handler integration" - invoke an integration with a fault objectContent Hi, I have some common faults that may arise in different integrations or different scopes of a same integration. The way to handle these faults would be the sam… -
How to change date formatContent Hi Expert, I need to change the date into e.g jun-2021 format without javascript function.Is it possible in OIC ?
-
Read SQLLoader format fixed length file in OICSummary Read file for staging in OICContent Hi, I am trying to read a fixed length file, which is my source. This file is in sql loader format. In on prem, the control f…
-
OIC - Standard vs EnterpriseSummary New OIC Instance - Standard Edition - showing Insights and Siebel adapter?Content Hi I've been working on an OIC Enterprise Edition (Gen 2 - 21.2.2.0.0 (210505.1… -
ERP Callback configuration for Financials ModuleContent Hi Experts, We can have multiple data sources and therefore require different callbacks for each data source and attached configuration has be done for the same.…
-
Execute select statement on an Oracle Database using variables for limit and offsetContent Hello, I need to execute a select statement on an Oracle Database using variables for limit and offset, but trying to execute the select like in the attached ima…
-
Getting error while uploading file to UCM from OICSummary Getting error while uploading file to UCM from OICContent Hi All, I am getting the below error while uploading the file to UCM from OIC with ERP adapter, Error R… -
Integration Customer Newsletter Spring 2021Summary quarterly customer updateContent It is time for the May quarterly update to Oracle Integration. With Spring in the air, we are excited to share all our exciting … -
auto scaling for OICSummary How to auto Scale an Oracle Integration InstanceContent Need some clarification on how scaling of OIC instance is working. After reading through following doc ht… -
fb diContent hello expert, we know the standard way to upload fb di to erp is 1> keep csv zip data on ftp from source system 2> read data in oic 3> use adapter to upload to e…
-
Usage of Callback action in OICContent Hi Experts, Can anyone help me with the usage of Callback action and its use-cases. Regards, Ankur -
Unable to Connect Azure DatabaseSummary Unable to Connect Azure Database using Microsoft SQL Server AdapterContent Hi I have been trying to connect the Azure Database by following the steps provided th…
-
ForEach ending before iterate all dataSummary Foreach ending on iteration 8 instead of 16 without showing errorContent Hello, I attached an excel file that is being interated in a for each composite in OIC..… -
traversing the rest response in OICSummary reading rest response of particular attributesContent Hi Folks, I am working on a poc and getting rest response as below. My requirement is to read the AccountNu…
-
Get Rest call result count evaluating to 0 even if it is 1Content HI, I have an integration where I'm getting the data from DB and pushing into VBCS BO's. So here before calling PATCH call for inserting the data in to VBCS BO ,…