Database
Discussion List
-
How Insert date field from csv into databaseSummary: What is the correct way to process a date to insert into a database? Content (required): Hi experts, I have a csv file on the ftp server like this: I have confi… -
Sequential in OICSummary: Hello everyone, can you tell me what I need to do to be able to visualize a sequence that already exists in the database with the correct schema? Content (requi… -
Oracle Database Adapter - SQL IssueSummary Issue while trying to create a SQL queryContent Hello guys, i'm trying to implement a simple query as code snippet but i'm receiving the following error: Error: … -
Unable to launch Data Transforms tool inside Database Actions of Oracle ADW after deploying ODI Web.Summary: Content (required): Hi team, After successful provision of Oracle Data Transforms instance, I am able to access the Data transforms from the web browser and aft…
-
Patterns to Extract Data from ERP Cloud > BI Publisher ExtractSummary: Maximum size of data we can get from ERP Cloud using BI Publisher Extract Content (required): Hello All, Do you have an idea what is the maximum size of data we…
-
OIC Parse XML from Database FieldSummary: We are storing an XML payload in a database field and need to pull it into an OIC integration as the payload for a co-located integration. Content (required): T… -
'IN' Operator in SQL select query is not working with dynamic values. (SQLServer Connection)Content Hi OIC experts, We are performing an operation on the table with select using following query. But It doesn't seem to work and there isn't a way to debug what's …
-
PLSQL arrays and Integration CloudHi All I have an xml array posting to a plsql table and record and that works fine. But I want to set up a GET to return that plsql table into an XML array. The error I …
-
APEX_WEB_SERVICE.MAKE_REST_REQUEST Calling OICHello Everyone! I have a situation, I have been using the APEX_WEB_SERVICE.MAKE_REST_REQUEST with the POST method(REST Call) to run the token based OIC Pooler integratio…
-
Database mapper showing parameters as arg1, arg2, arg3,arg4 instead of showing its names.Summary: Content (required): Hi team, We are trying to create a REST API by integrating an Oracle Database with OIC. So as we select the table name and after validating …
-
One way Procedure calls in Oracle DB AdapterSummary: Invoke Long running DB procedures is Oracle Database Content (required): We are Invoking Oracle Database procedure from OIC which on has only input parameters. …
-
How to fetch BLOB data(more than 10 MB) from data base to oracle cloud integration?Summary: In atp data base one column has blob data more than 10 MB. we need to handle this data in OIC Content (required): In OIC, we are invoking one procedure where re…User_2025-03-10-21-43-39-199 261 views 1 comment 0 points Most recent by Ganesh Jadhav-178018 Integration
-
Getting MySQL Error on OIC Caused by java.sql.SQLNonTransientConnectionExceptionSummary: Error Message:- DBReadInteractionSpec Execute Failed Exception Query name: [FetchRecordSelect], Descriptor name: [FetchRecord.Test]. Caused by…
-
Can we dump JSON file in ATP table using OICContent I am getting data from JDEdward ERP using rest API in JSON format but JSON is a very weird format and unable to call data in VBCS so I want to dump the JSON file… -
Issue on JSON rest service data insertion in ATP table through OICContent Hi Experts, I am facing an issue while inserting data in the ATP table through OIC. In JSON one child "PENN_SREQ_P41202Components_Repeating" element "item number…
-
When tried to connect to a Onprem Database with Connectivity Agent and a Wallet it throws an errorContent Hi guys, My connection tests successfully when tried on Sql Plus On-Premise and Java On-Premise. But it throws error on Oracle Integration Cloud Service. I am us…User_2025-02-11-13-31-40-371 15 views 2 comments 0 points Most recent by User_2025-02-11-13-31-40-371 Integration
-
Error While Configuring Oracle DBaaS ConnectionSummary Error While Configuring Oracle DBaaS ConnectionContent Hello, Iam getting the below issue, while configuring the Oracle DBaaS connection. Unable to test connecti…Sridhar Yerram-87959 20 views 2 comments 0 points Most recent by User_2025-02-11-13-31-40-371 Integration
-
OIC integration with Oracle NoSQL DBContent Hello, I would like to know if it is possible to integrate OIC with an Oracle NoSQL Database? Thanks in advance. -
Insert into multiple ATP tables from OICSummary Insert into multiple ATP tables from OICContent HI All As part of the integration we are fetching xml data from HCM which need to parsed and enriched to create t… -
How to read Data from .pdf filesContent Hi Team, we have a requirement to read data from .pdf files .Is it possible in OIC and if not the what are the other way to read the data from .pdf file. Thanks,…
-
How to Receive Multi-Part Form Data Json File as Attachment and Insert Data to DB TableContent How to Receive Multi-Part Form Data Json File as Attachment and Insert Data to DB Table? Please advise if anyone has any pointers/blogposts/solution in transform…Shivakumar Ayyanagowdar-Oracle 16 views 4 comments 0 points Most recent by Shivakumar Ayyanagowdar-Oracle Integration -
Read SQLLoader format fixed length file in OICSummary Read file for staging in OICContent Hi, I am trying to read a fixed length file, which is my source. This file is in sql loader format. In on prem, the control f…
-
Execute select statement on an Oracle Database using variables for limit and offsetContent Hello, I need to execute a select statement on an Oracle Database using variables for limit and offset, but trying to execute the select like in the attached ima…
-
Unable to Connect Azure DatabaseSummary Unable to Connect Azure Database using Microsoft SQL Server AdapterContent Hi I have been trying to connect the Azure Database by following the steps provided th…
-
OIC Call to OnPremise Stored Proc Times out frequentlySummary Synchronous OIC Call to OnPremise Stored Proc Times out frequently and sometimes retrieves data in 40 secsContent We have a App Driven Orchestration calling a St…
-
Oracle ERP connector not showing childs values when put the context codeSummary The EFF atributes are not show when I put the context codeContent Hi guys. I am using the oracle fusion ERP conector to call the itemVersion2 RestApi. However, w…User_2025-02-05-08-52-13-026 25 views 3 comments 1 point Most recent by Hemanth Lakkaraju-Oracle Integration
-
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…User_2025-02-10-07-41-15-235 117 views 5 comments 0 points Most recent by User_2025-02-10-07-41-15-235 Integration