Integration
Discussion List
-
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 …
-
Error upload pgp encrypted document to UCM using ERP AdapterHi Team, I am trying to encrypt and upload a document to UCM using the ERP adapter.I get the below error which doesn't say anything specific about the issue. Can anybody…
-
Which Event/Service can I subscribe to on ICS to inform full or partial receipt of the items of a POSummary We want to inform the full or partial receipt of the items of a PO line.Content Hello guys! We want to inform the full or partial receipt of the items of a PO li… -
List Multiple File With Same nameSummary: List Multiple File With Same name Content (required): We have a requirement where we need to list the files with the same name and read all the files with same …
-
How to check empty CSV file with HeaderSummary: How to check empty CSV file with Header. Content (required): Hi Expert, In Our project we are getting some source file with header but no data.Now we want to se… -
OIC FTP adapter - erroing out with UTF-8-BOM encoding. Any workaround?Summary: OIC FTP adapter erroring out when the xml file is of UTF-8-BOM encoding. Works well when its UTF-8. Content (required): We have an issue while reading an invoic…
-
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…
-
How can we add months to a string input field in OICHi Team, We are working on a requirement where we have to add 2 months to an input string field coming from another system into OIC. Lets say input field in 2022-01-01, …Ramit Bansal-259237 73 views 2 comments 0 points Most recent by Hemanth Lakkaraju-Oracle Integration
-
Timezone in my integrationHello all! I've alredy created an integration that download a snapshot from Oracle FCC, to a sFTP folder successfully with a desired file name. I added to the file name,… -
Is there a way to merge two responses into a single csvSummary: We have a requirement to merge two sources data/response into a single dataset/csv Content (required): The following data should be merged as single Data1 { mig…
-
XSLT solution to select from 1st source only nodes NOT present in 2nd sourceSummary: Have simple case where 2 XML sources are processed in a way where nodes from 1st xml file are excluded if they already part of 2nd xml file Brute force approach… -
Need to show all operation in the OIC WSDLSummary: Hi Team, I have a requirement where I would like to show all the operations under one WSDL when I import it in SOAPUI. Content (required): For Example, If the W…Veerakumar Subramani 32 views 3 comments 0 points Most recent by Hemanth Lakkaraju-Oracle Integration
-
Multiple atom feed rows for employee terminationHi, We are trying to send employee termination information to downstream applications. We are using the "termination" atom feed for the same. What I observed is for same…
-
CMK B2B and OIC B2BSummary: Customer already used EDI VAN for Inbound and Outbound Messages in the current architecture. As part of SCM Cloud implementation we need to route this messages …
-
Zip file operation not workingSummary: I am trying to zip the downloaded files from the SFTP server. It's working fine in one instance. When I import the same code to another instance, I am getting t…
-
Reposition of For Each/While and Switch activitiesSummary: Content (required): Is it possible to reposition For Each/While and Switch activities ? Version (include the version you are using, if applicable): Code Snippet… -
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…
-
How to skip a row based on particular value in OIC mapper.Summary: How to skip a row based on particular value in OIC mapper. Content (required): Hi Expert, I want to skip a particular row based on filter condition.Let say for …
-
trigger OIC integration from email sent to designated addressSummary: in need of something in terms of trigger OIC integration from email sent to designated address where integration would read email, confirms that subject is matc…
-
Is there any way to trigger an integration from the external email with attachments?Summary Is there any way to trigger an integration from the external email with attachments?Content Hi expert, I am looking for a way to trigger an integration from the … -
can i configure IDCS application to generate JWT for outbound API call?Summary: there decent number of white papers that describe how to configure IDCS to enable JWT/OAuth for inbound API calls to OIC endpoints, fro example https://wpsbutto…
-
For each in mapper causing translation issuesIn the FTP process in the mapper if we put a for-each loop to append multiple lines to the csv file it errors out with the error:- --------------------------------------…
-
Zip filenames are not printing correctly in ICS notification serviceSummary: I just printed below content in the ICS notification activity. Hi, Filename: Error_Report_2343324.zip Thanks, Admin ============================================…
-
BICC to OCI Storage ConnectivitySummary Connectivity from BICC to OCIContent We have connections from BICC (Oracle Business Intelligence Cloud Connector Console) to OCI (Bucket Storage) and OIC will ac…
-
What are the cons if the integration is scheduled for every 3 minutesSummary: We have requirement where we need to schedule the integration for every 3 minutes. Please let us know the pros and cons Content (required): Version (include the…
-
How to implement a "RequestHoldProcess" call from OIC to ERP Cloud utilizing an async callback?Summary: How to implement a "RequestHoldProcess" call from OIC to ERP Cloud utilizing an async callback? Content (required): When implementing the "RequestHold" call wit…
-
Get Binary content using SOAP AdapterWe are trying to use the UCM GET_FILE service to get the binary content of a file which we have to pass to another rest api for creating attachment in Document of Record…
-
SOAP trigger value not accessible inside IntegrationSummary: I have an App driven integration with SOAP trigger where value is received using a soap payload. When i try to assign that value anywhere throughout the integra…
-
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…