Database
Discussion List
-
MFT querytext for most current dated file in UCMSummary: Content (required): I have been working through an issue to try and pull ONLY the most current file using MFT from our UCM. To do this, I have tried altering th… -
How import a file to UCM from a tableSummary: How import a file to UCM from a table Content (required): Hi everyone, I have a fbdi files in a table and I try to import to UCM. The content is in a column of … -
Ingest files to WebCenter Content WCC or UCMSummary How to override an existing content/file in WebCenter. any configuration?Content Scenario: we are using "GenericSoapPort" SOAP WebService to ingest files to WebC…
-
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…
-
Can OIC consume BLOB or CLOBSummary DB Adapter is invoking a PL/Sql Procedure which is returning CLOB/BLOB as out parameter, Can we consume the same in OIC.Content DB Adapter is invoking a PL/Sql P…
-
OIC > DB Adapter > SQL Issue > Passing Date Parameter > Validate SQLSummary: OIC > DB Adapter > SQL Issue > Passing Date Parameter > Validate SQL Content (required): Hello All, I am facing this issue in the screenshot when I use TO_DATE …
-
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…
-
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…
-
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…
-
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 -
OIC REST - how to save xml payload to ATP clob column opaquelySummary OIC REST - how to save xml payload to ATP clob column opaquelyContent I am trying to build a simple REST integration that when called from Postman with an xml pa…
-
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…