Integration
Discussion List
-
Can't update individual row using Update lookup Rest APISummary Can't update individual row using Update lookup Rest APIContent Hi, I need to update the selected row value in lookup using OIC rest API, For example 'Row1' valu… -
What is the best practices of using Lookup in OIC for fetching records?Summary: Need Lookup best practices. Should we create integration specific separate lookup or there should be one common lookup(as key name value pair) to be used across…
-
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 383 views 5 comments 0 points Most recent by Oracle PaaS Consultant-Oracle Integration -
Query for specific instance id in activity stream log of OICSummary: We have enabled Service log for OIC - Gen2 and trying to find activity stream for a specific instance id which is not visible from OIC dashboard. Is there a way… -
Excel to CSV - OICSummary: Since FBDI accepts on csv format and we have requirement for scheduled integration to read a excel file and convert into csv followed by the mapping with FBDI t…
-
Unable to get proper callback when running a BulkImportData Job on Fusion from OICSummary: Hi, I am attempting to run a BulkImportData task using the Oracle ERP Cloud Connector on OIC. The import is working as expected, no issue on that end. My issue …
-
How to Get the xml data of a reportSummary: How to Get the xml data of a report Content (required): Hi All, We are looking for the web-service to get the xml data/output name of the report.Below is the sc…
-
Multiple sales order in single payload using rest apiHi, I am creating sales orders by Reading the CSV file. My questing here is I want to create all the sales orders at the time. If any error occurs I don't want to create… -
Slack Missing_scope users:read.email in OIC Slack AdapterSummary: Content (required): When we add the scope "users:read.email" in the connection then it gives us an error that this scope is not supported. We were able to add "…
-
Write an excel file using OICHi, Is there an option to write to an excel file in OIC? I am looking to upload this excel file in UCM or in a SFTP for a 3rd party to pick up?
-
Speed up Integrations that use REST APISummary: Is there a way to speed up REST api roundtrips to Fusion? Content (required): We have an integration that processes an inbound CSV file to update costs in inven… -
Using Number function to increment a Number to 1 Million fails in OIC MapperSummary: We have a requirement where Incrementing a Number beyond 1 Million makes a number be represented in Scientific Notation/Exponential format and not as a number X…Shivakumar Ayyanagowdar-Oracle 231 views 3 comments 0 points Most recent by Shivakumar Ayyanagowdar-Oracle Integration
-
OIC StageRead CSV-Insert records in sequenceSummary: Hi, I am reading the csv file using stage read and I observed that it is reading in sequential order but when I insert those records into database table it is n…
-
Callback flow version behaviorSummary: When invoking an integration with the SOAP adapter utilizing a callback, how does the flow version actually work? Content (required): We have integrations that … -
Editing Invoke co-located integration?Summary: Is there any way in OIC to edit the integration shape for invoking another Integration? Content (required): We are using the integration shape "Local Integratio…
-
Workato vs Oracle Integration CloudSummary: Content (required): Do you have any comparison chart between Workato and Oracle Integration Cloud for integrations with both Oracle and Non-Oracle systems? Vers…
-
Date and time conversionSummary issue by String to Date and TimeContent I have a scinario of getting String type Date and Time values from Source need to populate into DB as a timestamp fields.…
-
IntegrationSummary Validate a date in AICContent How can I validate any date whether it is a proper date or not in AIC? -
OIC - Read dynamic columns CSVSummary: Hi, I am having FBDI integration which reads 70 columns of filled data as CSV file from FTP location. So my integration is reading the file successfully. But th…
-
How to force an OIC Integration Instance to complete with PARTIAL_COMPLETION statusSummary: Hi, Does anyone know wether it is possible to force an OIC integration instance to complete with PARTIAL_COMPLETION status? Content (required): Does anyone know…
-
Oracle Integration Update Webcast June 16th 2022Summary: Oracle Integration Product Update Webcast Content (required): Attend to get the latest updates and innovations on Oracle Integration May 2022 release. Our Oracl… -
Add line break in XML fileSummary: Content (required): Hi experts, I am working on an integration which will generate an xml file, my schema is as follows:
-
OIC-Aborted to SucceededSummary: Hello All, Can OIC version 22.2.2 integration instance can be changed from Aborted to Succeeded without resubmitting the same? For one of our testing, we aborte…
-
Is callback possible in OIC for HCM cloud?Is callback possible in OIC for HCM cloud like we do with Oracle ERP cloud.
-
Stage File Action List operation returns empty list.Summary: A "list files" operation for a Stage File action returns an empty list, even though a previous FTP operation was successful. Content (required): Hello Integrati…
-
How to pass null value for LOV field in OIC mapper. How to remove tag from payload if its nullSummary: How to pass null value for LOV field in OIC mapper. How to remove tag from payload if its null Content (required): I am trying to update list of 9 DFFs via REST…Jaeyshree Kumaran Kalpana 923 views 3 comments 0 points Most recent by Jaeyshree Kumaran Kalpana Integration
-
Extract Data from SaaS to VBCS ApplicationSummary Extract Data using an OTBI ReportContent Hello, I have a requirement to retrieve data from our Oracle ERP Cloud applications. I need to extract the data via an O… -
OIC-Reprocess from last failureSummary: Hi, I do have one OIC long-running integration, basically, it is calling 3 external endpoints, suppose if it fails at the 2nd endpoint and the next time if I re…
-
Looping on String splitSummary: Hi, I am trying to achieve the following java logic in Oracle Integration Cloud. Basically I am getting comma separated string as input. I want to split the str…
-
Integration using OPA/Intelligent connector - best practice design?Summary: What is the best design to use the IA adaptor in an asynchronous way? Content (required): Currently: We are currently using the IA (formerly OPA) connector in I…