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
-
OIC SOAP Adapter - Get ESS Job Completion Status IssuesSummary OIC SOAP Adapter - Get ESS Job Completion Status IssuesContent Hi Could you please help me with this. i am not able to get the ESS job Completion status response… -
Remove Duplicate Records from CSV using OICSummary Remove Duplicate records from CSVContent Hi Team, We have a csv file which we download from source ( EPM Cloud). We need to remove duplicate records from the csv… -
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… -
Stage Action Zip results in Error due to folder does not existSummary Stage Action Zip results in Error due to folder does not existContent Use Case: In OIC, I am Listing the files from SFTP Server and running a loop to fetch a set…Shivakumar Ayyanagowdar-Oracle 435 views 5 comments 0 points Most recent by Oracle PaaS Consultant-Oracle -
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… -
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 … -
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 ? -
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… -
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… -
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 ,… -
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… -
Append operation in Data Stitch for Object type Variable is giving error.Summary Append operation in Data Stitch for Object type Variable is giving error.Content I was trying to read a file more than 10 MB from a FTP Server using Read File Op… -
ODI Marketplace V12.2.1.4.210517 - Classic ODI Compute isntace - does not start ODI Studio after InsContent ODI Marketplace V12.2.1.4.210517 - Classic ODI Compute isntace - does not start ODI Studio after Instance reboot error message is [oracle@oracle-odi-inst-kmnl sc…User_2025-02-11-15-11-21-763 25 views 0 comments 0 points Most recent by User_2025-02-11-15-11-21-763 -
OIC changing & to & when sending payload to Rest AdapterSummary OIC changing & to & when sending payload to Rest AdapterContent Hi, I have variables that I set with &, ie &InvoiceNumber=ABC in the Assign Mapper. When I run th… -
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… -
How To Schedule a Integration at the end of every monthContent Hi Expert, I want to schedule a integration at the end of every month.Can Anyone share me the steps and also the ical expression. Regards, Pritam -
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… -
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… -
Integration Error: Error in listing files in the remote directoryContent Hello! We encounter the following error when making FTP call (List Files operation) in one of our orchestrations. Anyone familiar or has encountered this issue b… -
ExtractAndPurge from Interface TablesContent We followed the Cloud customer connect post https://cloudcustomerconnect.oracle.com/posts/752bec430a to Purge the Interface table data using the "ErpIntegrationS… -
Migrating Integration to ICS to OIC one of Invoke adapter giving error and not saving.Summary Integration is working in ICS and that integration migrated to OIC . It is not giving configure option and having draft . When edit and save then it is giving er… -
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..… -
How to achieve File to base64 in OIC.Summary Here, how we can do File -> Base64Encode? and What operation we have to choose in the FTP adapter?Content I have a requirement, I have to convert the base64encod… -
Generating JWTSummary Generating JWTContent Hello Gurus, I have a requirement to generate JWT encoded token which is needed to again call another Auth REST API to get the actual Acces… -
HCM Adapter as a trigger , can't receive business eventContent Hello all, I'm using HCM Adapter as trigger , and choosed the business object to be (Business Unit). Then i've saved and enabled the integration . But when i ope… -
Oracle Integration Update Webcast June 10th 2021Summary IOIC webcast June 10th 2021 – Foundation for digital business- Product Management Webcast June 10th 2021Content I ntegration – Foundation for digital business- P… -
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… -
Ability to create job dependencies in OIC schedulerSummary When scheduling jobs in OIC, there is no option to create dependencies between jobs.Content When scheduling jobs in OIC, there is no option to create dependencie…User_2025-02-05-22-01-34-912 129 views 6 comments 3 points Most recent by User_2025-02-05-22-01-34-912 -
Run the Bulk Import ESS jobs paralleleySummary Run the Bulk Import ESS jobs paralleleyContent When invoked bulk import process with properties file having multiple rows to invoke multiple ESS jobs with respec…