Database
Discussion List
-
Fault Handler for Multiple OperationsSummary: I have the below flow in which 1) First using DB Adapter, selecting rows from database tables using select queries based on where condition 2) Pass the values f… -
OIC DB Adapter and REST API - LoopingSummary: 1) GetProductInfo is using DB Adapter named 'Product Information' to get all the rows from Oracle database; results are fetched using SQL statement based on the…
-
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…
-
TZ_OFFSET equivalent in xslt?Summary: is there an xslt function equivalent to the sql function TZ_OFFSET Content (required): I'm extremely new to OIC and xsl...I need to find a way to get the timezo…
-
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…
-
best approach to insert into multiple tables from OICSummary: Looking for the best way to proceed to bring in data with many collections of data within it Content (required): Hi. I am extremely new to OIC and just stumbled…
-
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…
-
Trigger Callback Integration after Custom ESS Job CompleteSummary: Is it possible to trigger a Callback Integration after a Custom ESS Job finishes your execution? Content (required): Hi, For this scenario, we have one custom E…
-
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…
-
"Mismatch with the server cert DN" while connecting from OIC/sql developer to ATP DBSummary: We are suddenly facing issue - "Mismatch with the server cert DN" today while connecting from OIC/sql developer to ATP DB in our all dev and prod environment. A…
-
How to hanndle special charcters while subscribing from AQ using AQ adpterSummary: Source : Oracle EBS AQ Target : Third party vendor Using OIC, we are subscribing the message from AQ(AQ adapter) in XML format using XSD which contains the valu… -
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…
-
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…