Orchestration
Discussion List
-
Is callback possible in OIC for HCM cloud?Is callback possible in OIC for HCM cloud like we do with Oracle ERP cloud. -
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… -
ERP Adapter issueSummary Error: The application has encountered an unexpected error. Please check the applications connection details, credentials and retry your request.Content I'm tryi…
-
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…
-
HCM ATOM Feed - Emp New Hire/Update Include Business Object checkbox disabledSummary HCM ATOM Feed - Emp New Hire/Update Include Business Object checkbox disabledContent Hi Everyone, The Include Business Object in HCM Atom Feed is disabled for Em…
-
Check OIC Integration Running StatusSummary: Hi Experts, I have this scenario in Oracle Integration Cloud, where Scheduled integration calls --> AppDriven Integration where AppDriven Integration is a long-…
-
'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…
-
Estimate End Time/Duration of a Scheduled IntegrationSummary: We have scheduled integrations that would process multiple files in a single instance. Is there a way we can identify the estimated end time/duration of the run…
-
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…
-
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.…
-
Item Update Event is not triggering upon applying filter conditionContent we are trying to capture Item Update business event in OIC with a specific condition. i.e capture only Master organization related events and neglect rest of the…Ranganadh Neelakantham 8 views 4 comments 0 points Most recent by Ranganadh Neelakantham Integration
-
OIC to Amazon S3 IntegrationSummary Fetching and Placing files in S3 buckets using OIC integrationContent Hi , We have a requirement where we need to fetch files from Amazon S3 buckets. We followed…