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
-
Direct Child Object filter - Rest APIContent Hi, We have created one custom object under Contract object. We want to fetch all the child records based on Child object value using Rest API. Currently we have… -
Can we get related resources of the Integration recipesContent Hi Experts, I have installed one of the recipes i.e "Oracle FTP HCM Create Worker". I wanted to test this end to end. Can we get the source file that is having r… -
New Oracle Integration Videos and a New and Improved Documentation Search ToolContent We have released a number of new videos about connecting on-premises applications to the cloud with the connectivity agent, key Oracle Integration capabilities, … -
Microsoft SQL server Adapter returns scientific number from tableSummary Microsoft SQL server Adapter returns scientific number format 1.101984E7 instaed of 110198407Content We have configured MSSQL adapter to read data from a table.R…
-
Expose table in DBCS as a REST EndpointSummary Expose table in DBCS as a REST EndpointContent Hi Team, What are the steps to expose a table in DBCS as a REST endpoint and how to invoke it to insert the data. …
-
Best way to output a node even if null? (foreach, choose does not output node as expected)Content How can I output a node as null if the foreach/choose condition is not met? Here's the source: 12312312312 alternatephonenumber createdbyuser …
-
OIC - Best practices for Migration between environmentsSummary Migration of Integrations in Oracle Integration CloudContent Hi, While migrating Integrations from test instance to Prod , what protocols should be followed. Is …
-
How to manage session ID while invoking cpq webservice through OICSSummary genrate session ID dynamicallyContent Hi All, Im trying to trigger data table soap webservice from OICS, have hard coded ,
-
ERP Cloud Business Event subscription error in OICSummary ERP Cloud Business Event subscription error in OICContent We have configured ERP Cloud connection for Business Events subscription per this document - https://do…
-
How to store file into database in blob type fieldContent Hi Team, I have a database table where there is one field of type blob in which I wanted to store images, pdf files. Wanted to read the files from FTP. Is this p…
-
unable to pass the attachment to rest based integrationSummary unable to pass the attachment to rest based integrationContent Hi All, I have requirement to pass the attachment from one integration to another Rest Integration…
-
Not able to getresponse from the child integration in mapper for next step in parent integrationSummary GETRESPONSE from child integration call is empty. Doesnt show response elements in mapper for next stepContent Hey Experts, I have an issue with calling child in…
-
Unzip file option SFTP OICSummary Unable to unzip optionContent Hi Gurus, We have 2 SFTP connections and we are not seeing the unzip option in one SFTP versus other. Only Difference is Security P…
-
How do I escape special characters when using Concat as a node value?Content I want to use the monitoring API detailed here: https://docs.oracle.com/en/cloud/paas/integration-cloud/rest-api/op-ic-api-integration-v1-monitoring-instances-ge…
-
Get metadata about integration/s already running?Summary How can I find out if the current integration is already running with the same tracking information?Content Is there a way within an integration to gain informat…
-
Parent - child data in oicContent Hi Experts, I have two CSVs as attached and both the CSV has a common attribute id. I want to create a REST API that will read both the files, combine the result…
-
Issue when using existing integration flow in new integrationSummary Call - Integration action doesn't let me map outputsContent When I configure a step in my new integration to call an existing integration I'm having an issue map…
-
Using OIC to Make JDBC calls to AS400Summary JDBC Calls using OICContent Hello Everyone, We have a requirement where we need to intergrate AS400 DB to OIC. AS400 supports JDBC calls. Is there a way we can u…
-
Parent - child data in oicContent Hi Experts, I have two CSVs as attached and both the CSV has a common attribute id. I want to create a REST API that will read both the files, combine the result…
-
Unstructured csv to xsdSummary Unstructured csv to xsdContent Requirement is to Process unstructured csv, sample csv structure 1. c1,c2,c3,c4,c5 2. c1,c2 3. c1,c2,c3 record one and two are rep…
-
Report of Integration Run Times...Performance monitoringContent We have an integration that could be called thousands of times a day. Performance hasn't been an issue, but I am expecting people to ask for a report of average …
-
REST Query ParametersSummary REST Query ParametersContent Hi Experts, Below REST endpoint returns array of records with startdate and enddate as two of the many elements. startdate and endda…
-
FBDI File Export to FTPSummary FBDI File Export to FTPContent Hi, We want to start our first integration with File Based Orchestration. For this purpose we first want to schedule a file upload… -
ERP Cloud AdapterContent Hi guys, In the ERP Cloud Adapter, how can I make a Purchase Requisition? Is there any Role I need to release this API or is there really no API in the Adapter? … -
ESS jobcall from OICS getting erroredSummary failing to call ess job from OICSContent HI All, Im trying to submit one ess job request from OICS, below are the error and payload. can someone help me. Error: …
-
Information about MuleSoftContent I am currently working as an OIC Developer with 2 years of experience in IT Industry. I came to know about MULESOFT from one of my colleagues. Is it worth to hav…
-
Can we call OIC / ICS Wrapper Service from ESS directly?Summary Current structure : ESS > BIP Report > OIC/ICS Wrapper service. I want : ESS > OIC Wrapper Service. Is it possible?Content Greetings Everyone, Existing :- * BI S… -
List of Business events in 19BSummary list of Business events available in 19B for OM & Shipping which OIC can listen.Content Hi, can any body point me to the list of Business events avialable in 19B…
-
How to pick up files from FTP directory based on File creation time?Summary How to pick up files from FTP directory based on File creation time?Content Hi Everyone, We are able to successfully download file from FTP server based on File …
-
How to create a complex object in a stage file CSV by combining information from different sources iContent Hi experts, I have the requirement to download some data from a BI report and also UCM files I am using two BI reports, in OIC I have two nested foreach loops I …