Database
Discussion List
-
Unable to use same dataset with different SQL queries for OAC Canvas in Oracle Analytics Cloud.Content We are trying to put different canvases from the same dataset, for example, we are plotting a piechart using filters emp_id = 1 with an attribute column. The sec…User_2025-02-11-06-39-02-630 17 views 0 comments 0 points Most recent by User_2025-02-11-06-39-02-630 Integration -
Not able to fetch the REST API generated by OIC in OCEContent Hi, We are trying to fetch the REST API which is successfully generated by the OIC. (REST API is generated by fetching the Data from Oracle Database and OIC is g…User_2025-02-10-13-20-02-679 33 views 1 comment 0 points Most recent by Hemanth Lakkaraju-Oracle Integration
-
Object(global) of class cannot be converted toContent Hi, While integrating OIA with Oracle database in Oracle Integration Cloud(OIC), as we mapped global(id) of OIA a default parameter to a primary key id of Oracle… -
Getting a list of errors while Integrating OIA with Oracle DBContent Hello, While integrating OIA with Oracle DB, as we activate the integration and insert values from OIA UI to the Oracle DB to store inside the database, below ar…
-
GET/POST operation to make a REST API put values onto a UIContent What operation should we use in the REST API to put values to a UI , as we are trying to push the values from one component (OIA interview) to (OCE) through OIC.…
-
How to sort records in OICSummary How to sort records comin from source based on a field valueContent Hi Team, We are trying to processing the records after we sort them. We are getting data from…
-
How to connect Snowflake databse in OICSummary How to connect Snowflake databse in OICContent Hi All, How to connect Snowflake database in OIC if we can able to connect, please suggest what adapter we can use… -
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 287 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…User_2025-02-05-09-32-34-013 15 views 4 comments 1 point Most recent by User_2025-02-05-09-32-34-013 Integration
-
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…User_2025-02-08-04-00-49-804 13 views 0 comments 0 points Most recent by User_2025-02-08-04-00-49-804 Integration
-
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… -
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…