Database
Discussion List
-
Simple type deserialization issue while upserting data to Salesforce Custom ObjectSummary Simple type deserialization issue while upserting data to Salesforce Custom Object thorough OICContent Hi Team, We are trying to upsert data from DB to Salesforc…Jagadeesh Kumar Thontapaka 283 views 0 comments 0 points Most recent by Jagadeesh Kumar Thontapaka Integration -
Is that TRUNCATE query not supported?Summary Is that TRUNCATE query not supported?Content Hi, When I am using the TRUNCATE query in Run on SQL Statement, OIC is showing SQL statement syntax is not supported… -
Reading a DB column containing a JSON string and passing it to a third party APIContent Hi everyone, we are storing a JSON string in a DB column, and we would like to parse it in OIC and sending it to a third party API using the Rest Adapter. How ca…
-
Database Adapter - Issue with datetime datatype of Database columnSummary Issue with datetime datatype of Database columnContent Hi Everyone, We are connecting to on-premise database and issuing insert statement. The insert statement c…Karthick Rajarathinam 31 views 1 comment 0 points Most recent by Hemanth Lakkaraju-Oracle Integration
-
Oracle Integration Cloud running SQL statement in Oracle ATPSummary Getting error when I ran sql statement in ATP using oracle integration cloudContent Hi, I am executing sql statement using oracle integration cloud in ATP databa…
-
Using OIC to Make JDBC calls to AS400Summary JDBC Calls using OICContent Hello Everyone, We have a requirement where we need to intergrate AS400 DB to OIC. AS400 supports JDBC calls. Is there a way we can u…
-
Information about MuleSoftContent I am currently working as an OIC Developer with 2 years of experience in IT Industry. I came to know about MULESOFT from one of my colleagues. Is it worth to hav…
-
Avoid DBCS in OICSummary Store in variable to use in Multiple processContent Hi Gurus, I have a integration which is dependant on diffrent callback responses. The flow is as below. a) I …
-
we are trying Enqueing operation in AQ adapterSummary We are trying Enqueing XML Payload as a Data into Queue Table. For that we selected Queue Details in AQ adapter and structure of the payload is NO (we selected O…
-
We are trying to write json file into stage file and we able to write. now we are trying to read samSummary We are trying to write json file into stage file and we able to write. now we are trying to read same json file in other integration with filename and directory.…
-
How can we use 'request is html form' in REST adapterSummary How can we use 'request is html form' in REST adapterContent How can we use 'request is html form' in REST adapter. I have configured REST Adapter Resuest payloa…
-
We are getting Time out Error while JS Function running (java script is running too long (15000ms).Summary We are getting Time out Error (java script is running more the 15s).Content Hi, We are generating JWT Token using JavaScript in OIC and Script is taking 12s to e…
-
Using ATP Database with DB AdapterContent Hi Team, I am looking for an option to move from DB System to ATP. We have integrations built with DB Adapter and now when I want to move to ATP, it would take a…
-
How to use sequence without a databaseSummary We need to make a unique msg_id from a sequenceContent We need to make a unique msg_id from a sequence without having acces to a database. Is it possible i OIC. …
-
how can we read the data of pdf file from Stage File ReferenceSummary we have Base64Encode value of pdf file and we have to store those pdf file into AWS s3 bucket.Content Hi, we have Base64Encode value of pdf file and we have to s…
-
Select records in Batches from DB.Content We have a requirement to pull records from DBCS. The data/volume is very high and its required to pick records in batches. Example we have 200K rows of data in a…
-
Deploy NodejS AngularJs with Mysql on Compute InstanceContent Hello, i have an application, done with nodejs Angularjs and Mongodb and i want to deploy it on oracle. But i want to deploy it on my compute instance and have a… -
How can we Store PDF file in AWS S3 using OIC REST ADapterSummary we have requirement for file should stored in S3 as pdf fileContent HI, we have requirement for file should stored in S3 as pdf file we have s3 rest url awsXXXXX…
-
Error IN/OUT Paraamter in DBaaS adapterContent Hey, I'm using a dbaas adapter to perfom a query on a database. I will get this error currently: Error message is - DBReadInteractionSpec Execute Failed Exceptio… -
DBCS cloud serviceSummary When you license DBCS cloud service do you get file storage and way to store in bound and outbound files ?Content We will be licensing OIC for Oracle Fusion SaaS… -
Not able to update the status of a sales order via REST APISummary Getting Error when trying to update a status of an orrder via rest apiContent Hi , I am trying to change the status of a sales order using a rest api . (EndPoint…
-
Fusion HCM table which stores all the data present as part of .dat fileSummary Fusion HCM table which stores all the data present as part of .dat fileContent Hi, I need a HCM common tables name which stores all the data goes to HDL via .dat…
-
OIC REST Adapter Security as OAuth Resource Owner Password CredentialsSummary OIC REST Adapter Security as OAuth Resource Owner Password CredentialsContent I have configured REST Adapter connection Security as OAuth Resource Owner Password…
-
AQ Adapter (trigger) is not visible in inetgrationsSummary AQ Adapter (trigger) is not visible in inetgrationsContent Hi, I Created one AQ adpter with role as Trigger. When i am trying to configure in integration AQ Adap…
-
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…