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
-
CSF-Key setup in missing in latest OIC documentationSummary: Hi, When we are checking the OIC documentation i.e. https://docs.oracle.com/en/cloud/paas/integration-cloud/erp-adapter/prerequisites-creating-connection.html#G… -
Maximum number of records in Yardi IntegrationSummary: Content (required): We are working on Integration between Oracle Cloud and Yardi and I am asking for maximum number of records can be done in one transaction to…
-
Looking for the possible ways to connect to snowflake and sitecore via OICSummary: Hi Team, we need to connect to snowflake and sitecore via oic. Could you please suggest the best way? Thanks Vicky Content (required): Version (include the vers… -
Configure Bearer Token in OIC ConnectionSummary: Content (required): We have basic username and password of E-Verify portal to validate the user. E-Verify portal has 2 step authentication. First one is to pass…
-
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-…
-
Business Event - Sales Adapter Best practiceHi, We have requirement to push the Account details to external system whenever new record or updating the existing record. I have 2 questions Shall we use Business Even… -
'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 …
-
Append to file in UCMHi, We need to send certain details on trigger of erp business events to downstream applications. The issue is we cannot use ftp or sftp in between nor can we use any pa…
-
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…
-
EPM REST API calls facing user lock or password expiration issuesSummary: EPM REST API calls facing user lock or password expiration issues Content (required): Hi Team, We are using EPM REST API calls in OIC integrations for uploading…
-
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…
-
Business Event - Triggering PointHi, We planned to use 'Contact Created Event' from Engagement Cloud adapter. Oracle Engagement Cloud Adapter Capabilities OIC integration event will trigger when we crea…
-
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…
-
Oracle commerce cloud call back for file import process from OICHi, We are integrating with Oracle Commerce cloud from OIC, the use case we need to achieve bulk import process with "executeImport" object and we are able to upload a f… -
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, …
-
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…
-
Oracle Integration Update Webcast: CX Integration and Extension Best practicesSummary: Oracle Integration Update Webcast: CX Integration and Extension Best practices Content (required): Attend to get the latest updates and innovations on Oracle In… -
Download Narrative Reporting daily backupSummary: Download the daily backup to a sFTP directory. Content (required): Hello my dear friends! Is there a way to download the daily snapshot backup from Narrative Re…
-
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…
-
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…
-
Generating Column Header using FTP AdapterI want to add a single column header in my CSV file being produced by FTP adapter in OIC. I understand we have to create a repeat node in the OIC mapper to add a header.…