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
-
Met error when using nvl function and parameter in ATP run SQL statementHi All, I have an ATP in OCI using run a SQL statement: When I added the function nvl, it shows error: and there is no error when nvl without parameter: May I know why? … -
Unable to pass value dynamically in OCI object storage OIC callI am using OCI object storage action within OIC to perform actions like upload, delete and list objects. Where the compartment name, bucket name etc.. is selected from d…
-
Maximum limit reached js expression oicSummary: We are getting maximum limit reached when executing a custom JavaScript library function as part of our oic integration flow in OIC 3. We understand that there … -
In OIC, we cannot open downloaded PDF documents via REST API after Gen3 upgrademapping the Stream Reference (PDF doc) received from Quickstat and with encodeReferenceToBase64 and mapped to target parameter: Summary: One of our OIC integrations perf… -
API gateway call integrations? without authenticationSummary: Hi Experts I want to expose the integration to external users i.e. for anonymous access without authentication. One way i came to know is by using API gateway b…
-
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…
-
We need to sort an array of fields in OIC by the most recent last updated date.Summary: We need to sort an array of fields in OIC by the most recent last updated date (in timestamp format), eliminate duplicate values, and retrieve the unique record… -
Few files not being listed in OIC List files until touched or saved againSummary: We have Fusion scheduler placing file on to FTP folder, which in turn will be listed and processed by OIC , we do not see those files listed in OIC. But when tr…
-
How to do reprocessing for Event driven integrations in OIC Gen 3?Summary: We need to receive payloads through an OIC-exposed URL, which serves as the endpoint for a publisher integration subscribing to a custom OIC event we created ba…
-
Oracle Integration Cloud predefined vs custom rolesOracle Integration Cloud has predefined roles, e.g., ServiceMonitor, ServiceViewer. Can you create custom roles for Integration Cloud? Can you modify the privileges of a…
-
Supported SSH ciphers in OIC3We have SFTP connections in OIC with a third party file server and they are dropping support for the following ciphers: AES128-CTR, AES192-CTR, AES256-CTR. The supported…
-
Using bulk import facility in Snowflake using OICHello, I am very keen to use Snowflake adapter in OIC. We got the connection setup. I have a file that arrives in OIC SFTP location and its in a format that I can straig… -
How to get more than 100 atom feeds using HCM AdaptorHow to get more than 100 atom feeds using HCM Adaptor We are trying to debug HCM integration using atom feeds. Currently, in output, we are getting only one record. Is t…
-
how to make OTBI to take semi colon (;) separated string as multiple parametersSummary: I am calling OTBI report using SAWSESSIONSERVICE from OIC. when I pass multiple parameters into OTBI through the OIC mapper its not generating output. Content (…
-
how to restrict access for users in IAM for oracle integration / visual builderSummary: Hi Experts I have a customer instance and i'm the admin for the Oracle integration instance. But i want to give access to developers to build integrations and n…
-
OIC instance scheduled to be upgraded to gen3, but was not upgradedSummary: OIC instance scheduled to be upgraded to gen3 between 10:00 PM PDT Apr 6 to 12:00 AM PDT Apr 7, 2025, but was not upgraded. No email sent by Oracle. Will the up…
-
Oracle HCM Fusion API OAuth with Entra IDSummary: Does Oracle only support JWT Assertion Grant Type? I am asking this because it seems to depend on Trusted Public Certificates from MS Azure/ EntraID and those a…
-
We are getting "404 Not Found" while calling languageAI service through OIC ?Summary:We are getting "404 Not Found" while calling languageAI service (we need to call batchLanguageTranslation) through OIC ? We need to call "languageAI service" (ur… -
Import Journal Cloud ERP mapping is failing with the error for debit and credit amountSummary: We are facing the below error for all the transactions however, the same data is getting processed from SOAP UI application.Any pointers are highly appreciated.…
-
REST API to fetch value from DFF (Attribute1) fieldREST API to fetch value from DFF (Attribute1) field. Please suggest how to get value from DFF using REST API: /fscmRestApi/resources/11.13.18.05/projects. With the help …
-
Send email with OCI Email Delivery service from OICSummary: Send email with OCI Email Delivery service from OIC Content (please ensure you mask any confidential information): Hi, Can we call the OCI Email delivery servic…
-
OIC message consumption for ERP EventsCould anyone please help us determine the number of messages OIC can consume in an hour if we use the ERP event for receiving data from Fusion?
-
Delete Delegation APISummary: I want to delete the delegation rule using REST API. But the below API is not working as it is getting the below error: If anyone encounter this, please let me … -
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… -
Sharp Surge in Server Network Usage Due to Agent ConnectivityHi Team, We have observed a significant spike in server network consumption following the agent connectivity with the OIC instance. This substantial increase has impacte…
-
How to call a HTTP request to an external api using base64 encoded signed payloadSummary: We need to send a signed payload (a combination of a signing algorithm, JSON payload, and signature) as a base64 encoded string to an external API using an HTTP…
-
How to access File Server in OIC3?Summary: I think there was an update recently and now I can't find the File Server. The old path was Settings\File Server\Settings. Now there is no File Server under Set… -
Disable Basic Auth for invoke Integrations in oic version 3Summary: Disable Basic Auth for invoke Integrations in oic version 3 Content (please ensure you mask any confidential information): disable the ability for a developer f… -
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 …
-
OIC EBS: Failed to deactivate the integration. The endpoint url may or may not by up and running.Hi, We are seeing an error while deactivating an OIC integration by deleting the EBS event subscription at trigger, using factory REST API as well as UI. Error: Failed t…