Database
Discussion List
-
Pull data from on-premise Oracle DB into PaaS database using DB linkSummary Pull data from on-premise Oracle DB into PaaS database using DB linkContent Hi All, Please advise how to Pull data from an on-premise Oracle DB into Oracle PaaS …User_2025-02-04-13-12-58-802 11 views 2 comments 0 points Most recent by User_2025-02-04-13-12-58-802 Integration -
Error: While Importing Java jar file in OIC LibrariesSummary I have java code as jar file its not importing in oicContent Hi, I have java code as a jar file for cryptography. While I importing jar file into OIC Library I a… -
Integration - Database Adapter Polling orderSummary Integration - Database Adapter Polling orderContent Hi All, In which order Database Adapter Polling works? Even though it is using distributed polling and multit…User_2025-01-29-03-07-51-472 53 views 1 comment 0 points Most recent by Anuj X Maheshwari Integration
-
API Specifications for scheduled integrationSummary How to create API Specifications for scheduled integration?Content So I understand how to create API specifications for integrations that start with a REST adapt… -
ERP and SCM Cloud Data Extracts to on-premise data warehouseSummary Need advice on best option for extract data from ERP/SCM Cloud to on-premise wartehouse. Looked at BI Cloud Connect, but believe that requires a UCM Server on-pr…
-
Integration with HCM Extract Run & Retrieve FlowSummary This is to take note the best practices to observe when integrating OIC with HCM's Extract Run-Retrieve FlowContent Hi Team, I'd like to ask for inputs from the … -
Is there a way to see response payload using ICS Database?Content Hi All, As per the recommendations we want to disable tracing of the integration(ICS). But if any issues how to debug? Is there a way to see request/response pay…
-
How to pass arguments to DBaas adapter in OIC?Summary How to pass arguments to DBaas adapter in OIC?Content Hi All, We have requirement to pass arguments to the sql query. Below is the sample query. SELECT FNAME, LN…User_2025-01-31-15-33-33-933 219 views 8 comments 1 point Most recent by User_2025-01-31-15-33-33-933 Integration
-
Connecting to OCI(Oracle Cloud Infrastructure) DB from OICSummary Not able to establish connection to OCI DBContent Hi Experts, We have moved from DB classic to DB OCI for database management. The OIC connectivity agent is inst…
-
Problem with Stored Procedure InvokeSummary Unable to invoke Stored Procedure when has Associative Array as inputContent Hi, I am trying to invoke a stored procedure from OIC through DB adapter, the invoke…
-
Runtime Fault/Exception Handling in OIC (Oracle SOA Fault Policy Functionality?)Summary Is Oracle SOA Fault Policy Functionality also present in OIC? Especially handling runtime fault on server sideContent Hello OIC Gurus, Oracle SOA has this Fault …
-
Can we Poll a table by considering more than one column flag using DB AdapterSummary I want to poll a table by checking two column flag values. Is that possible in ICS?Version 18.3.3.0.0User_2025-01-29-03-07-51-472 6 views 3 comments 0 points Most recent by Nagireddy Tadi-Oracle Integration
-
Issue Activating ICS Integration - DB Adpater IssueSummary Facing Issue while Activating ICS Integration with DB adapter configured.Content We are now facing issue in activating and ICS integration with DB adapter. I'll …
-
Retrieve SOA-MDS passwordSummary How to retrieve the SOA-MDS password and configure the db based MDS connection from jdeveloperContent We created a SOA instance and corresponding database instan…
-
Does OIC have data warehouse features?Summary Does OIC have data warehouse features?Content We need to be able to archive files from source locations. Does OIC have any archival or data warehouse features?
-
Downtime Handling in OICSummary We encountered intermittent connection (2-3 minutes of random downtime) in OICContent Hi, We encountered intermittent connection (2-3 minutes of random downtime …
-
Custom SQL queries against Cloud ERP via OAICSSummary Custom SQL queries against Cloud ERP via OAICSContent Hi All, I am building an integration in OAICS, based on (I expect a common scenario) where we are creating …User_2025-01-30-19-13-07-190 43 views 2 comments 1 point Most recent by User_2025-01-30-19-13-07-190 Integration
-
Select statement with DB2 connector doesn't return anything to mapSummary Using the DB2 connector to connect to DB2 over port 446, select statement validates and generates and xsd but there is not outbound mapping.Content I administer …User_2025-01-31-15-40-56-878 42 views 8 comments 2 points Most recent by User_2025-01-31-15-40-56-878 Integration
-
ICS: Agent not showing in DB Connection Agent Confguration after installing the On-Premise AgentSummary The agent is not showing in the 'Configure Agents' interface when doing DB Connection setup in ICSContent Hi, We are using ICS Standard Edition, Version: 18.2.3.…
-
Connection Timeout in REST adapterContent Hi, I have a use case where I have to insert the data from BI report into the database. I have exposed the data insertion as REST service using ORDS. In some cas…
-
ICS Database connection after patching on DB prevent "existing state of packages has been discarded"Summary ICS Database connection after patching on DB prevent "existing state of packages has been discarded"Content Hi together How can I prevent after patching the data…User_2025-01-31-16-33-46-752 37 views 5 comments 1 point Most recent by Hemanth Lakkaraju-Oracle Integration
-
How to migrate integrations from One OIC instance to another including database packagesSummary How to migrate integrations from One OIC instance to another including database packagesContent We have built around few custom integrations , we would like to m…
-
OIC Mapping with DBSummary OIC Mapping with DBContent Hello Experts, I am trying to map the source/target parmeters which are coming from a Stored procedure and one of the out params is cu…User_2025-01-31-20-25-22-591 30 views 3 comments 1 point Most recent by Hemanth Lakkaraju-Oracle Integration
-
ICS asynchronous callSummary ICS asynchronous callContent Hi, It is possible to invoke a database procedure with ICS asynchronous, without waiting of a result? Regards Fabian.User_2025-01-31-16-33-46-752 37 views 9 comments 1 point Most recent by Hemanth Lakkaraju-Oracle Integration
-
ICS Write request XML into the databaseSummary ICS Write request XML into the databaseContent Hi, It is possible to write the request XML from the SOAP trigger as CLOB into a 12c Oracle Database table? Regard…User_2025-01-31-16-33-46-752 29 views 2 comments 1 point Most recent by Hemanth Lakkaraju-Oracle Integration
-
Response variable not found on the databaseSummary Response variable not found on the databaseContent Hi Team, I'm facing an issue while developing an integration. where as integration monitoring, the value is pr…Janardhan Kothapalli 16 views 18 comments 0 points Most recent by Hemanth Lakkaraju-Oracle Integration
-
MySQL adapter cannot connect (needs JDBC jar?) Using On-Prem agentSummary MySQL adapter cannot connect (needs JDBC jar?) Using On-Prem agentContent I have an OIC instance with an On-Prem adapter installed within my firewall. The On-Pre…User_2025-01-31-15-40-56-878 27 views 2 comments 2 points Most recent by User_2025-01-31-15-40-56-878 Integration
-
Error While inserting Data into DBaas through ICS "Inserted value too large for column:"Summary Error While inserting Data into DBaas through ICS "Inserted value too large for column:"Content Hi All, I am encountering the following error while trying to ins…