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
-
A 400 Bad Request ErrorSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Read excel file with multiple tabSummary: Hi I want to read excel file which having multiple tab. For E.g Excel having 3 tab name like A,B and C. I want to read B tab. How we can achieve this. Content (…
-
Ignore null values in REST API outputHi All We are using REST API to query data based on list of values using IN, however null values are being extracted for the criteria. If there a way for null values to …
-
How to Enable SSO Between ERP Fusion and Visual Builder (Different Identity Domains)Hi everyone, In our environment, we're using OIC4SaaS. I’ve developed an application in Visual Builder and I want users to be able to access it directly from ERP Fusion …
-
How do Oracle Cloud Customer Portal communications work from an integration?Summary: I'd like to validate what integrations are available for Customer Portal. Could you please share the currently available documentation regarding the integration…
-
How to schedule OIC integration on every 7th of month excluding weekendSummary: How to schedule OIC integration on every 7th of month excluding weekend Content (please ensure you mask any confidential information): Hi Expert, We have a requ…
-
Using OAuth for OIC Gen3 to integrate with Fusion HCMSummary: I am working on setting up OAuth to be used in OIC Gen3 to access Fusion HCM REST/SOAP Endpoints. I have 2 OCI Tenancies, 1st tenancy is for SaaS Services (Host…
-
Oracle OIC Download file to OIC stage from file serverI am writing an OIC program that reads the file from 'remote' SFTP and segment file in the OIC hosted file server. In order to efficiently read the file, I'd like to 'do…
-
OIC db adapter sequencing issue with insert statementSummary: We are using OIC gen 3 (25.04.1) to insert records in atp database. In the db adapter, we are using a sequence. We have noticed that sequence used by the db ada…
-
Can we Subscribe an event from Integration in EDMCS (Enterprise Data Management Cloud Services) ?Summary: We are trying to publish changes from EDMCS Applications to Oracle CDM, SQM, and other applications using a event-based trigger subscription within Oracle EDMCS…
-
Oracle HCM Cloud Adapter : Import Bulk Data using HCM Data Loader (HDL), ProcessId returning ErrorInconsistent behavior of HCM Adapter for HDL, ProcessId not returning valid value and even HDL process not started in fusion. getting below message in ProcessId response…
-
Parse response wrapper as JSONSummary: Hi, We have an integration in which we are sending some data to a database, the data we want to send is in this format: UPLOAD result for candidateID:…
-
Internal Server Error: OracleContext missing required property 'oic.service-instanceWe are getting this error in OIC Gen3 when customer invoke to REST service. curl -L 'https://OIC URL ' -H 'Content-Type: application/json' -H 'x-b3-flags: 0' -H 'x-b3-pa…
-
How to Process Attachments using SWA(SOAP with attachments) in OIC using SOA AdapterSummary: Hi Everyone, We have a requirement as below There is an external SOAP service which responds datahandler xml element which holds cid to the csv attachment file …
-
Can OIC create folders dynamically in an SFTP server at runtime?I need to create folders dynamically on an SFTP server as part of an integration flow in Oracle Integration Cloud — for example, to organize files by date or type. From …
-
Any workaround for dynamic attachments in notifications?Summary: In OIC notifications, if multiple attachment references are configured, all must be present at runtime or the action fails. The number of attachments can't be c…
-
How to update Integration response in SaasSummary: Hi I am calling integration from VBCS page and we are getting response from the integration . Now we need to use this response to update few columns in Saas? Re…
-
how to rename the file name inside the ZIP when using ScheduleReport -SOAP ServiceSummary: Hello Team, We are using scheduleReport SOAP Service and using the same we are generating ZIP file. The problem is that the filename inside the zip file we want…
-
pdf attachment failing for AR debit memo with ErpObjectAttachmentService web serviceHi Team, We are tring to attach pdf to AR Debit memo with ErpObjectAttachmentService soap web service gettting an error.
-
REST API failing when using Basic AuthHi experts, We are facing the following issue: We need the ability to trigger OIC integrations using the ESS Jobs. To achieve that, we create a report using the REST API…
-
how to send tables in OIC email Notification toolHello, is there a way to send tables with information in it using the email notification tool in OIC? a quick example would be helpful, thanks in advance
-
OIC 3.0: Delay in processing large XML from OTBI – How to improve performance?Summary: Hi community, I'm looking for ideas or best practices to improve the performance of an integration in Oracle Integration Cloud (OIC v3.0) that is currently taki…
-
Unable to update schedule parameter of Ad-Hoc Run in OIC using REST APIUnable to update schedule parameter using REST API. Seems it only updates for scheduled run and not for Ad-hoc runs. I tried both true and false for "run-as-schedule" pa…
-
OIC 3 - Default Handler not loopingSummary: Default handler in a file reading loop doesn't go to next record on an error Content (please ensure you mask any confidential information): I added a default ha…
-
Integrating IBM MQ using OICSummary Integrating IBM MQ using OICContent Dear All, when I checked there is no official adapter available for connecting to MQ ? Is there a way we can integrate with M…
-
How to Map Array of String Objects in OIC Integration FlowSummary: Hi Community, I’m seeking guidance from OIC experts regarding a mapping challenge I’ve encountered. If anyone has faced a similar requirement, I’d appreciate yo…
-
Run Integration from postmanSummary: Hi I am trying to run Integration from postman. Here i have given trigger connection details. While running from postman i am giving Oauth details . ALso able t…
-
OIC PGP Decryption ErrorSummary: Hi, Keys have been generated using the guidance in Oracle documentation. Test file encrypted using Kleopatra. When OIC attempts to decrypt the file we receive "…
-
XPath expression failed to execute Error during evaluation of XPath "ora:doXSLTransformForDocHello Friends, I am getting an xpath error while mapping xml string using parseXML(TOInputPayload) function to stage file Below is code snippet from code view of OIC Map…
-
OIC Integration Failure: cannot parse XML payload part: payloadSummary: Hi everyone, We're encountering an error during the map-to-JSON conversion. This issue has occurred for two individuals, but there's nothing unusual about their…