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
-
How to calculate signature in OIC using HMAC sha 256Summary Calculate signature in OIC using HMAC sha 256Content Hi All, In OIC, How to calculate signature using HMAC sha256 Is there any script available in OIC calculate … -
Unable to access 'Workers' business resource using the Oracle HCM Cloud adapter in OICSummary: We are configuring the Oracle HCM Cloud adapter in Oracle Integration Cloud (OIC) to use the "Workers" business resource. However, after selecting the correct s… -
Can I install OIC Agent on premise server that is not connect with internet?Summary: Can we connect an Oracle Integration Cloud agent to a On Premise server that is not connected with internet? Content (please ensure you mask any confidential in…
-
Oracle ERP Cloud ESS jobs callbacks indefinitely queued and not sending to Integration in Gen 3 OICSummary: Hello community. I have an issue with one of my Oracle OIC Gen 3 Integrations. I have a parent integration that triggers a series of ESS Jobs. Those scheduled j…
-
The attribute INVENTORY_ITEM_ID is missing for service getProductRelationShipContent Hi Experts, I'm trying to execute the "Oracle Salesforce ERP Opportunity to Order" recipe and getting below error: The attribute INVENTORY_ITEM_ID is missing for… -
OAuth Callback - Failed retrieving access token from service providerSummary: Getting this error "[OAuth Callback] Failed retrieving access token from service provider" when trying to get an Authorization code. Config was done as per docu…
-
Refresh token expiry issue in Snowflake adapter in OIC Gen3Summary: Refresh token expiry issue in Snowflake adapter in OIC Gen3 Content (please ensure you mask any confidential information): We are using the OIC Gen 3 Snowflake … -
OIC Mapping - Remove end of line from Data from source systemSummary: HI, We have data coming from source system with 'end of line' characters, which is causing the issue in Oracle fusion ERP import process. Is there mapping funct…
-
Unable to find private endpoint parameter in OIC terraform codeSummary: Hello Team, Our project requires us to set up a Private Oracle Integration Cloud (OIC) using Terraform, which involves creating OIC in a private subnet within a…
-
Access issue while accessing object storage using oracle integrationI am using Rest Connection to upload file into object storage bucket by using oracle integration cloud. I am using Oracle Signature Version 1 for security and added all …
-
hcmRestApi/scim/Users filter optionsWe are calling the following HCM Rest API: https://.oraclecloud.com/hcmRestApi/scim/Users When filtering with any of the "roles" attributes (i.e. https://oraclecloud.com…
-
Zip files with password using Stage File Operation in OICSummary Zip files with password using Stage File Operation in OICContent Hi, Is it possible to Zip files with a password using Stage File Operation in OIC? Thanks
-
OIC integrations version controlHello, We are currently looking into some possibilities on how to implement version control for our integrations in OIC. We would love some suggestions about which tools…
-
Add Image in the OIC email NotificationSummary: Hi I want to add image in the OIC email notification body part. Please suggest. Content (please ensure you mask any confidential information): Version (include …
-
OIC > DB Adapter > SQL Issue > Passing Date Parameter > Validate SQLSummary: OIC > DB Adapter > SQL Issue > Passing Date Parameter > Validate SQL Content (required): Hello All, I am facing this issue in the screenshot when I use TO_DATE …
-
JMS Adapter Dynamic Destination QueueSummary: Is there a way to set the destination in JMS adapter connection in run time to make it dynamic? (See highlight in yellow) Content (please ensure you mask any co…
-
How to create Multiple line from singleSummary: Hi I want to create 2 line from one line request payload. basically i am looking 2nd line with same information like LineNumber=1. 2 8128
-
OIC Stage File Read from xml variableI'm attempting to get data from a BPI report into OIC and a SOAP connector. I can run the report, and receive the response. I then decode64 the ReportBytes element and a…
-
error while calling APP Driven integration (with payload) from Application composer using POSTMAN.We are creating an OIC wrapper in Application Composer where we need to pass some parameters and a request body to trigger the integration. However, when triggering the …
-
What is the efficient method for performing data updates (data fixes) in Oracle Cloud ERP?Summary: We often receive requests for updating data in Oracle Cloud ERP (Oracle Fusion ERP), particularly regarding DFF values. Typically, we utilize FBDI for these upd…
-
OIC FTP - get last modified dateSummary: How to convert a file's last modified time to a date in OIC Content (required): In OIC Gen2 I'm downloading some files from an SFTP server, but I also want to a…
-
ESS job "Process Electronic Bank Statements" from OIC or ERP, resets file permissionsSummary: When processing files using the ESS job "Process Electronic Bank Statements" from OIC or directly from ERP, we have observed that the process resets or wipes ou…
-
How to fetch specific custom extension attributes from microsoft graph api in OIC integration.This filter setting is working in Postman tool, but the same thing is not working in OIC integartion. Example : $filter = onPremisesExtensionAttributes/extensionAttribut…
-
sample csv format for RFI.EXT_FIN_SYSTEM_FILES_CONTENT table file_content column?Is there any sample csv format for the data present in the RFI.EXT_FIN_SYSTEM_FILES_CONTENT table file_content column? For all data_type. RFI version 24. -
Debug Disappeared automatically from ProductionSummary: Debug Disappeared automatically from Production Content (please ensure you mask any confidential information): Hi, From our Production OIC instance the Debug Ch…
-
Object Storage file download using REST APII am able to download file using stf adopter Write file option, but issue is that the name is not getting dynamic. Below are the steps to get the file Below are the step…
-
OIC - Is there a way to check UTF-8 encoding while reading a file from SFTP?Summary: Hello, Is there a way to check if a file is UTF-8 encoded while reading a file in OIC? There is a requirement to process a file only if it is UTF-8 encoded Than…
-
Is there a way to configure OIC Gen3 to use Exchange 365 as the MTA?Hi team, We recently had a scenario where our email limits of OIC(10k) were breached due to high volume SI testing. Since we are still on Gen2, we requested Oracle to ra…
-
Should all non production OIC gen2 instances be upgraded to OIC gen3 before Production move to gen3?Summary: Can we have one non production environment in Gen2 even after upgrading Production to Gen3, at least for 2 weeks? Is it a mandate that all non production enviro…
-
How to create REST connection with Hash-based method authentication (HMAC) code in OIC?We have to build an integration to connect with Interfolio application which uses HMAC based authentication. How do we create connection in OIC with HMAC?