Integration
Discussion List
-
Best Practice for OIC to Cloud DB: DB Adapter or RESTful Services?Summary Better way to connect in Oracle DBCS from Integration Cloud (OIC/AIC)Content Hi, I'd like to hear your inputs as to which approach is better in terms of efficien… -
FTP File name Pattern - OIC GEN 3I am trying to move a file from source FTP location to Target. so when the source file name is "test.txt" i am trying to rename the target with "test_%yyMMddHHmmss%.txt"… -
What mechanism OIC followed to ensure data reached to EBS (or destination server)Mechanism followed by OIC to ensure data to EBS (or destination server) are same as OIC passedMuhammad Naveed Haroon 22 views 2 comments 0 points Most recent by Muhammad Naveed Haroon Integration -
Download large files from HTTPS link in OICWhat can be a good workaround to download files larger than 100mb over HTTPs in OIC integration? There is a mandatory compliance requirement from one of the EU countries…
-
OIC3 Post Upgrade: Difference between OAuth and Basic AuthenticationSummary: Hi All, We are trying to test the integrations in OIC3 post upgrade which having REST calls with Basic authentications in Gen2 . As per the Oracle , Post Upgrad…
-
Sign the Message Content with XML Digital Signature in Oracle Integration Cloud (OIC)Summary: Hi Team, I have a requirement to sign the XML body with an XML Digital signature using privateKey. Is there any SOAP or Rest API to handle this? OR Any other so…
-
How to enable an external oracle database to update table in Oracle DBaaS hosted in OCISummary: Is there a way to connect to a DBaaS table from an Oracle on-prem database? How to enable an external oracle database to update table in Oracle DBaaS hosted in … -
Substring last 5 characters from a string - OIC GEN 3Need to Substring last 5 characters from a string from an integration in OIC GEN 3. I am expecting substring("r e dwood", -5, 5) will result "dwood". So I tried below fo…
-
How to pass collections to PL/SQL package from OICSummary: We are in the process of transferring all direct table operations (insert/update/delete) from the OIC database activity to a PL/SQL package. However, we are enc…
-
Consume Cloud HCM's Atom feed in real-timeSummary Has anyone got OIC Publish-Subscribe pattern working for atom feedContent I understand how we can poll atom server using a scheduled OIC integration periodically… -
How to process more than 1000 feeds from OIC HCM Adapter Atom FeedSummary: We have a requirement to process more than 1000 feeds for a single run through HCM Adapter Atom feeds. But in the HCM Adapter under Max entries to process list …
-
OIC High-Volume Data TransformationContent Hi, We have a project for ERP Integrations (FBDI Import and Load) using Autonomous Integration Cloud. For the GL Integrations, the expected flow is: 1. Read the …
-
Invoke Request Job Set using OICSummary: I am not able to invoke ESS Request Job Set using OIC. I am getting error in using connection itself. Can someone help or in case of any blogs/materials Content… -
Connected OIC using EBS adapter but not able to find business event related when item is create ,ordSummary Connected OIC using EBS adapter but not able to find business event related when item is create ,order creation and customer creation etcContent Connected OIC us…
-
SFDC Bulk Job is not returning job id on a custom objectSummary: I am trying to load data into SFDC Custom object via bulk job 'update' operation using SFDC Connector. My integration is completing with no errors but SFDC Bulk…
-
Performance issue while loading time entries via Rest API in OICSummary: We are facing significant performance issue when loading time entries through the Rest API in OIC. Its taking around 1hr to load 2.5k records, but the expected …
-
Enabling OAUTH in OIC gen3Summary: Hello Team, Our lower instances got upgraded to OIC generation 3. After the upgrade, OIC REST API calls with basic authentication are not working. To overcome t… -
Fusion - Apex integrationHi Experts, We are using oracle fusion application cloud ERP(SAAS). We also have paas services (OIC4Saas and apex on DBCS) for saas extensions. We wanted to use Oracle F…
-
Duplicated error when zipping fileHi all, I'm facing an issue in the OIC Gen3 24.08. When the code will zip the folder with the CSV files to load into Cloud (in FBDI format), the code failed and return t…
-
OIC3 post upgrade, not able to access swagger and test consoleTrying to test the integration post upgrade, getting above error. But our integration is in active state.
-
Append variableSummary: Append global variable ans use the nodes into the object refered variable Content (please ensure you mask any confidential information): help me pleaseeee all e… -
OIC: Multiple schedule frequencies and schedule ParameterHello All - Now, OIC Schedule supports multiple schedule frequencies () , but how can we submit multiple schedules for a single Integration, each with a different value … -
total results changing when offsetSummary: We have observed when making certain rest calls with offset and limit the total results is changing and limiting our access to information. For example, when {{… -
fetch refresh token in REST callSummary How to fetch refresh token in OIC REST callContent Hi All, We have configured REST OAUTH as Resource owner password credential with access token URI in connectio…User_2025-02-08-06-30-58-076 45 views 6 comments 0 points Most recent by Rajkiran-Oracle Integration -
Capturing x-amz-request-id and x-amz-id-2 Headers in OIC Integration to AWS S3Summary: I'm facing an issue with an OIC integration that sends files to Amazon S3. Some requests are failing with an error, and AWS support has requested the x-amz-requ…
-
OIC Integration with Parallel API callSummary Look for solution to call single API in parallelContent Hi Team, I've requirement to call an API for 30 k to 50 K times which is taking very long . Is there a wa… -
When I use the Integration Adapter in gen 3 I cannot see integrations from other projetctsSummary: I have 2 projects. One is going to be "Library" of common integrations. The other is my test project. When I try to use the "Integration Adapter" to call one of… -
Salesforce Adapter OAAuth2Summary: Hi Team, we are configured the OIC Salesforce adapter as below documentation and everything seems to be ok. Oracle also confirmed same on configuration. However…
-
I'm having an issue when trying to use an API to create lines to a selected Invoice.The error is "You must provide a valid value for the Purchase Order Number attribute. (AP-810667)" but when i checked for the PO was opened body: { "LineNumber": 3, "Lin…
-
Looking for options without connectivity agent to poll filesSummary: Is there anyway we can create a polling service for files without File Adapter and not scheduling integration for OIC SFTP file drop zones? Content (please ensu…