Integration
Discussion List
-
For Start and Stop OIC instance API provided by Oracle what kind of authentication needed?Summary: When using the Start/Stop OIC instance API provided by Oracle what kind of authentication should be used? I have been trying to call the below APIs available in… -
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…
-
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…
-
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…
-
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?
-
REST_REQ_PLD_ERR Error while calling a REST Service using POSTContent Hi All, I am having an issue while calling the REST Service from OIC. The error details are as provided below. Error Message -
OIC Integration with Kafka ERRORSummary OIC Integration with Kafka ERRORContent Hello All, We are getting an error message when we try to setup a scheduled orchestration using the Kafka adapter in OIC …