Orchestration
Discussion List
-
OIC Best PracticesSummary: OIC Best Practices Content (required): Hi, We are looking for OIC best practices to be followed across organisation. So that every team working on OIC integrati… -
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…
-
FTP EndPoint > List Files > File Name PatternSummary: FTP EndPoint > List Files > File Name Pattern Content (required): Hello, When we use the File Name Pattern bWorker%yyyyMMdd%.zip, the List Files operation does …
-
Extract json output in Integration CloudContent Hi Experts, There is API which sends the json response. The json response contains the json keys are dynamic as below: "custom_fields": { "100147": { "updated_at… -
How to Escape special charters (like space) in query parameters in REST adapterSummary: How to escape special charters (like space) in query parameters in REST adapter. OIC is encoding the value for Space -> + instead of %20 Content (required): Act… -
Ability to Store Values in ArraySummary: Ability to Store Values in Array Content (required): Hello All, In the integration below, I am iterating on the files in a specific directory and doing a Read F…
-
Need JSON schema for Creating JSON response for successful records via OICSummary:Need JSON schema for Creating JSON response for successful records via OIC Content (required):I have an app driven oic integration that takes in array of employe…
-
First record of stage write is always getting missedSummary: Content (required): I am passing a json as input to my app driven integration. Input [{"name":"ABC","PersonNo":"123"},{"name":"DEF","PersonNo":"456"},{"name":"G…Jaeyshree Kumaran Kalpana 11 views 4 comments 0 points Most recent by Jaeyshree Kumaran Kalpana Integration
-
FTP Connection Not Working Properly After Change Password Multiple TimesSummary: FTP Connection Not Working Properly After Change Password Multiple Times Content (required): Hello All, I am working on the integration below in which I have ad…
-
Ability to keep the integration running when the FTP connection lostSummary: Ability to keep the integration running when the FTP connection lost Content (required): Hello All, My integration uses FTP connection to List, Read, and Move f…
-
3rd Party FTP – OCI – HCM Integration > Best PracticesSummary: 3rd Party FTP – OCI – HCM Integration > Best Practices Content (required): Hello All, We are working on an integration which reads HDL files from a directory on…
-
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 13 views 5 comments 0 points Most recent by Oracle PaaS Consultant-Oracle Integration -
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 11 views 3 comments 0 points Most recent by Shivakumar Ayyanagowdar-Oracle Integration
-
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…