Database
Discussion List
-
Oracle Database adapter showing error - The connection to the database has been refused.Summary The connection to the database has been refused. Please check connection parameters, ensure database is reachable and review the firewall.Content Hi, I have crea… -
Unable to test connection "MYSQLCONNECT".Summary Unable to test connection "MYSQLCONNECT". [Cause: CLOUD-0005]Content Hi, i am trying to connect on-prem mysql db usign agent. i am getting below error. Unable to…
-
OIC - Creating virtual primary key DB AdapterSummary OIC - Creating virtual primary key DB AdapterContent HI Team, I am trying to do a merge operation on a table(On Premise) which doesn't have any primary key const… -
Error while translating message to native format.Summary Error while translating message to native format.Content Hi , I am trying to do write operation (CSV file) using the FTP adapter in OIC, I am getting below error…
-
Instance SchedulerSummary Does OIC have Instance SchedulerContent Hi Team, I am checking whether there is any instance scheduler to stop and start the OIC instances. I want to stop the OI…
-
How to call REST API using Http PATCH MethodSummary In Java how to call REST API (json) using http PATCH methodContent We have a requirement to update Planned orders in Cloud SCP from EBS. To update the planned or…
-
How to load large volume of CSV file to VBCS business object using OICSummary How to load large volume of CSV file to VBCS business object using OICContent I am developing inbound interface in OIC. I am going to get large volume of CSV fil…Hemen Shah-90655 59 views 7 comments 0 points Most recent by User_2025-02-06-07-13-00-563 Integration
-
Connectivity issue between SOACS and Pluggable DatabaseSummary We receive Resource Dead Exception for the Datasource that we use to connect PDB from SOACSContent Hi Team, We are connecting to Pluggable Database from SOACS. R… -
Invoice Extraction using EBSSummary What are the ways Invoice can be extracted using EBS in OICContent What are the ways Invoice can be extracted using EBS in OIC. i know using Business event is an…
-
Read File in Segments to REST Service insert to ATP databaseSummary Read File in Segments to REST Service insert to database results in all rows written in each segment readContent I have a very large file to import to my integra…User_2025-02-05-14-51-55-798 49 views 6 comments 0 points Most recent by User_2025-02-05-14-51-55-798 Integration -
Perform On Table - Select operation is not working as expectedSummary Perform On Table - Select operation is not working as expectedContent Hi , I am trying to fetch data from two tables. I am doing it with "Perform operation on ta…
-
What's the difference of "For Each" action and adding for-each during mappingContent Hi experts, In integration we are reading one file which has multiple lines, after that we want to call a DB procedure for each line(line value as input paramete…
-
Oracle DBaaS Adopter to ATP Adopter MigrationSummary Oracle DBaaS Adopter to ATP Adopter MigrationContent Hi All, We are in the process of Upgrading the Classic Database to ATP Cloud Service. In this DB, we have an…User_2025-01-31-15-27-19-928 39 views 10 comments 2 points Most recent by User_2025-01-31-15-27-19-928 Integration
-
Using Integration Service with Azure and AwsSummary Connectivity with Azure and AWS with Oracle Integration CloudContent My customer is interested to Integration Service. They are considering to implement datalake…
-
Remove trailing zerosSummary Remove trailing zeros of numberContent Hi, I have my input text as 0000001780936400. I should remove leading and trailing zeros in the number and the result shou…
-
How to load overtime information into Oracle HCM?Summary How to load overtime information into Oracle HCM?Content Hi Everyone, I have a requirement to load overtime information of an employee from a 3rd party system to…
-
Error Creating Connection for Oracle DBCSContent Hi All, Can you please guide me how to create a connection for Oracle Database Connection with DBCS. PFA Screenshot of the details entered while creating connect…
-
Accessing Integration User Name in OrchestartionSummary Logged in user infromationContent Hi, Use Case: In ad-hoc run of scheduled integration I am populating a Database table and I also want to populate the username …User_2025-02-05-11-44-44-738 33 views 9 comments 1 point Most recent by User_2025-02-05-11-44-44-738 Integration
-
OIC Agent Installation - UnknownHostException from DbaaS serverSummary OIC Agent Installation - UnknownHostException from DbaaS serverContent We had followed https://docs.oracle.com/en/cloud/paas/integration-cloud/integrations-user/…
-
IntegrationContent I have to update the a staging table with the values from the input file. I have to run the following query in AIC. UPDATE staging_table SET active_flag = :activ…User_2025-02-05-09-32-34-013 35 views 3 comments 0 points Most recent by User_2025-02-05-09-32-34-013 Integration
-
OIC Timeout connecting to Database on CloudSummary OIC Timeout connecting to Database on CloudContent Hi All, I have heard new DB adapter is being rolled out that won't need an agent to be installed on Cloud DB, …User_2025-02-05-11-44-44-738 21 views 0 comments 2 points Most recent by User_2025-02-05-11-44-44-738 Integration
-
Integration ApporachContent Hi, Our customer have DB Cloud, OIC (Oracle Integration Cloud), JCS (Java Cloud Service) and Fusion Cloud (SaaS). We have tried to integrate the third party syst…
-
How to catch the error message in response of Fault DetailsSummary How to catch the error message in response of Fault DetailsContent Hi All, I had an unhandled error in one of my integration. Please see the highlighted in my at…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
-
how to update database with the database adapter?Summary need to update rows based on a value found in one of the fieldsContent Hello Gurus, I'm processing data from a database using the DB adapter. I'm able to get dat…User_2025-02-04-13-35-35-440 18 views 2 comments 0 points Most recent by User_2025-02-04-13-35-35-440 Integration
-
DBCS - ConnectionContent Hi, We have tried to connect the Oracle Database Cloud Service using 'Oracle Database' adapter. But it is error out. How to create connection for DBCS. Thanks, M…Mohana Gopal S-Oracle 37 views 12 comments 0 points Most recent by User_2025-01-31-15-27-19-928 Integration
-
Run a select clause in ATP database with 'in' Operator using OIC ATP AdapterSummary Run a select clause in ATP database with 'in' Operator using OIC ATP AdapterContent Hi, RestAPI structure : { 'accountNum' : '123456' 'product' : ['abc','def','g…
-
Run a select clause in ATP database with 'in' Operator using OIC ATP AdapterSummary Run a select clause in ATP database with 'in' Operator using OIC ATP AdapterContent Hi, RestAPI structure : { 'accountNum' : '123456' 'product' : ['abc','def','g…
-
Connecting Oracle Integration to Oracle ATP - Issue with SequencingSummary I am not able to understand from where the sequence is picked up.Content In Oracle ATP DB : Created new sequence CREATE SEQUENCE ZEB_TEMP START WITH 1000000 INCR…
-
Oracle DbaaS Test Connect Failure in ICSSummary ICS Test DbaaS Connection failing after updating the schema passwordContent A number of integrations in ICS using a Oracle DbaaS Connection. The connection was c…
-
How to move IAR file from one OIC to Another OIC instanceSummary Move IAR file from one OIC to Another OIC instancContent I have Export the IAR file from One OIC Instance. 1. Is it IAR having All the dependencies like lookups …