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
-
Oracle Process Automation (OPA) Error ENGINE-03051Summary: Error while running a process automation Content (please ensure you mask any confidential information): I tried to create a sample OPA using the below Oracle Li… -
Cannot edit same imported project into 2 Gen3 instances in the same cloud at same time.Summary: I have 2 Gen3 Instances Dev3 and Test3. If I import the same project into each instance, then edit both at the same time. The first one I open "loses lock" with… -
Fusion to Third party API Connectivity issueSummary: Hi Team We are facing random issue while connection Third party system(LIMS) through Fusion Via OIC. same set of records it is processing and some time it is fa…
-
Error in "ReadEnrichedFileInSegments" activity stream after OIC Gen3 UpgradeSummary: Error in "ReadEnrichedFileInSegments" activity stream after OIC Gen3 Upgrade Content (please ensure you mask any confidential information): After OIC Gen 3 upgr…
-
Advice Required: On Demand Integration ExecutionSummary: On Demand Integration Execution Content (please ensure you mask any confidential information): Hi Experts, We have a requirement to invoke OIC based integration…
-
OIC Connection import workaroundHi All, is there a workaround to import Connections in OIC just like how Integrations and Lookups are being imported? I checked existing REST endpoints but there is none…
-
ATP Adapter or ORDS REST Services: What’s the Optimal Solution for Integrating with OIC?Summary: We are in the process of integrating the Oracle ATP database with OIC to facilitate certain business logics. With the anticipated large data volumes, we are try…
-
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"…
-
Large volume file processing OICSummary: OIC Integration takes very long time to process (> 8 hours for 50k records in the input source file). Looking forward for suggestions or corrections to improvis… -
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…
-
download the XSD file from the OIC Integration?How to download the XSD file uploaded into an OIC Integration in Gen 3 version?
-
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…
-
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…
-
OIC Gen 3 and "Design-time built-in APIs"?The Oracle Integration 3 eligibility checker is suddenly giving me the warning "DT factory api's should be accessed using Oauth in Oracle Integration 3. Change Basic aut… -
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 passed -
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…
-
OIC Table SchemaHi Everyone, I would like to ask if there's a way to know what is the schema of the table configured in the OIC. Currently modifying an integration and I need to configu…
-
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 … -
Available quantity item details are not flowing back to OFS from fusion-OIC standard integrationSummary: Hi Team,Can you kindly help on below use case scenario and recommended approach to handle it. Use case: • When parts/items consumed in OFS activity by field tec…
-
Triggering OIC using ESS without BIP routeSummary: This is requirement from client where they dont want to give access to OIC to business users and want to trigger the OIC integration by passing parameter using … -
Implementing Decline reason requirement in OTM as Mandatory?Summary: What is the approach in implementing the decline reason requirement as mandatory when the shipment is declined, and what are the ways to develop the solution? C…
-
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…
-
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 …
-
how to enable SSO login for OIC gen3Summary: Hi Team I am using SSO login option to login into fusion application. Same way I want to use SSO and login into OIC gen3 instead of username and password. Conte…
-
integration apex and fusion for ssoHi 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…
-
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…
-
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… -
Centralized location to see a list of all Open API endpoints for integrations within an OIC instanceSummary: I can view the metadata for individual OIC integrations by clicking on their endpoints. However, I'm curious if there's a more efficient way to obtain a compreh…
-
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.
-
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 {{…