Database
Discussion List
-
How to fetch the errors from an xml string that were catched within the scope in SOAP/REST service bSummary How to fetch the errors from an xml string that were catched within the scope in SOAP/REST service based integrationContent While using SOAP/REST service for inb… -
source ID not available in the database record, we have to collect the missing source ID and we haveSummary source ID not available in the database record, we have to collect the missing source ID and we have to send those IDs to the source.via email.Content Hi, I have… -
How to read data from DBCS & Convert to FBDI Format in OICContent Hello all, We have requirement to automate the Requisition FBDI Import into Oracle ERP cloud. Our source system enters the data into DBCS Table. I need inputs on… -
Stored procedure invocation errorContent I am unable to invoke stored procedure through OIC. We have used ATP DB to create Store procedure and same ATP DB is being used in OIC. As soon as control reache…
-
How to connect Oracle Apex in OIC to Oracle EBSSummary I want to register page apex page created in OIC in Oracle Ebs? Can someone help to register?
-
SFTP ArchivingSummary SFTP ArchivingContent Dear All, May i know the best source to learn about SFTP Archiving.
-
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…
-
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…
-
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 81 views 0 comments 0 points Started 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 12 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…
-
DB Adapter reflects new columnSummary DB Adapter DOES Not reflects new columnContent When we add a new column in table, in OIC we have to delete the whole mapper which comes along with the adapter. I…
-
OIC IBM DB2 Adapter & AS400Summary DB2 AdapterContent Hello All, I understand OIC has a prebuilt IBM DB2 adapter which allows to perform CRUD operations for DB2. However another Document Doc ID 24…
-
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. …
-
fetch refresh token in REST callSummary How to fetch refresh token in OIC REST callContent Hi All, We have configured REST OAUTH as Resource owner password credential with access token URI in connectio…Sumanth Kunimakki-236116 26 views 5 comments 0 points Most recent by Sumanth Kunimakki-236116 Integration