Orchestration
Discussion List
-
'IN' Operator in SQL select query is not working with dynamic values. (SQLServer Connection)Content Hi OIC experts, We are performing an operation on the table with select using following query. But It doesn't seem to work and there isn't a way to debug what's … -
How to validate and return the name of empty variablesSummary: Validate that there are no null input parameters and, if necessary, identify the name of the null parameter to return it in a response Content (required): Hi ex…
-
Get Last successful run date and time for scheduled orchestrationsWe need to get the last successful run date of a scheduled orchestration so that we can pull the data from Oracle SAAS accordingly. Followed this blog but it didnot work…
-
Rest API call improve performance in OICSummary: Improve Performance while doing rest call in OIC Content (required): We have a requirement where we need to call an Oracle Project Rest API which updates the ta…
-
Switch Case Limitation in OICSummary: Is there a limit on the number of Switch Conditions you can use in a Switch Activity? I checked the OIC Documentation but nothing says about it. Thanks ahead! -
Value is not getting reassigned in For eachSummary: Value is not getting reassigned in For each Content (required): I am reading a file using Read File in Segments and using a for each to iterate the records of R…
-
ReadFileinSegments throwing errorSummary: Content (required):Im downloading report data using downloadReportDataChunk operation. After that i use a stage write with opaque schema. Both these operations …
-
OIC : Add while loop to scope without rewriting the whole thing?Summary: Is it possible to add a while loop outside of an existing scope, to nest that scope, without having to rewrite the whole scope? Content (required): Is it possib…
-
Oracle OIC - Read option in FTP adapter with the xsd zip is not workingSummary: Read option in FTP adapter (Invoke Schema- XSD capabilities) with uploaded xsd zip is not working. The zip file has multiple xsd files with interdependencies. C…
-
How to concat a repeating element valueSummary: I have to build an integration.We send a request and we get an XML response.We are consuming the message from the outbound queue.Attaching the XML message.I wan…
-
Flat File ReadingSummary: I have one requirement as mentioned to read in the ATP database in two tables. What are the best possible ways to read the file considering it to be more than 1…
-
Accessing a file from OIC staging directory via a javascript functionSummary: Has anyone experienced accessing a file from OIC staging directory via a javascript function i.e. passing the file reference/ stream reference of the file to th…
-
Elements are blank when Read File in Segment operation is usedSummary: Elements are blank when Read File in Segment operation is used Content (required): I'm trying to read a structured XML using the Read File in Segment operation …
-
Publish Subscribe Architecture in OICContent Hi, We have below requirements for few of the Integrations in OIC (similar to on premise SOA). Since Oracle no longer offers "Oracle Message messaging service" a…
-
List of Values for schedule parameters in IntegrationSummary List of Values for schedule parameters in IntegrationContent Hi All Can we create list of value based schedule parameters in OIC ? For example we can have an int… -
Can we dump JSON file in ATP table using OICContent I am getting data from JDEdward ERP using rest API in JSON format but JSON is a very weird format and unable to call data in VBCS so I want to dump the JSON file… -
Issue on JSON rest service data insertion in ATP table through OICContent Hi Experts, I am facing an issue while inserting data in the ATP table through OIC. In JSON one child "PENN_SREQ_P41202Components_Repeating" element "item number…
-
When tried to connect to a Onprem Database with Connectivity Agent and a Wallet it throws an errorContent Hi guys, My connection tests successfully when tried on Sql Plus On-Premise and Java On-Premise. But it throws error on Oracle Integration Cloud Service. I am us…User_2025-02-11-13-31-40-371 15 views 2 comments 0 points Most recent by User_2025-02-11-13-31-40-371 Integration -
How to consume business events outside OICContent Hi All, Is it possible to consume SAAS business events outside OIC. Please let me know the other options to consume business events. Thanks Harish
-
Grouping XML data using Read File In SegmentsContent We have a requirement where we need to read a BIP report which is a XML file. Each record in the XML file represents a header and a line information. We need to …
-
Delete scheduled integration parametersSummary Delete scheduled integration parametersContent Hi Team We added some parameters for scheduled integrations and I see there is no option to delete the parameters.…
-
OIC - How to invoke BIP ws and read output dataSummary How to invoke BIP web service and parse/read the output in OIC?Content Hi everyone, How to invoke BIP web service and parse/read the output and share the parsed …
-
Need Solution to read fbdi format file from UCM , transform in OIC to FBDI format and invoke ESSSummary Need Solution to read fbdi format file from UCM , transform in OIC to FBDI format and invoke ESS jobContent Need pointers for the integration road map for manual…
-
How to Receive Multi-Part Form Data Json File as Attachment and Insert Data to DB TableContent How to Receive Multi-Part Form Data Json File as Attachment and Insert Data to DB Table? Please advise if anyone has any pointers/blogposts/solution in transform…Shivakumar Ayyanagowdar-Oracle 18 views 4 comments 0 points Most recent by Shivakumar Ayyanagowdar-Oracle Integration -
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..… -
OIC Call to OnPremise Stored Proc Times out frequentlySummary Synchronous OIC Call to OnPremise Stored Proc Times out frequently and sometimes retrieves data in 40 secsContent We have a App Driven Orchestration calling a St…
-
Passing parameters in schedule based OIC integrationSummary Schedule OIC integration based on parameter.Content Hi All, I want to schedule OIC integration(scheduled orchestration) based on parameter values. I am having 2 … -
source ID not available in the database record, we have to collect the missing source ID and we haveSummary source ID not available in the database record, we have to collect the missing source ID and we have to send those IDs to the source.via email.Content Hi, I have…
-
OAuth Credentials for Rest APISummary OAuth Credentials for Lookup Rest APIContent I am using Rest connection to update Lookup. Rest API is configured with OAuth credentials. using the scope urn:opc:…
-
Wait in SYNC App DrivenContent Hi Everyone I know using wait is anti-pattern, but we have multiple scenarios where we need to use wait/sleep for couple of seconds in OIC. One way to do is from…