Database
Discussion List
-
How to read tab delimited file in oic integrationSummary: We have to read a text file from FTP server. File structure is bit complex and we cannot use directly from csv (tab delimited) and not from XSD schema. I use cs…
-
Is it possible to download csv files from OneDrive on OIC Integration?Summary: OneDrive + OIC Content (please ensure you mask any confidential information): I have a requirement where I must download CSV files from an integration, is this …
-
DBCS Table import issueSummary: While importing DBCS table , getting below error. Content (please ensure you mask any confidential information): Version (include the version you are using, if …
-
Can we use sql hints in OIC DB adapter while running a SQL statement?Summary: I want to use a SQL hint in OIC DB adapter to run a SQL statement . When I click on validate query it says success . But on finishing the configuration the proj…
-
Oracle DBAAS Connection Error: ORA-12504 - Listener Not Given SID in CONNECT_DATAHi, I'm encountering an issue with our Oracle DBAAS connection. We've got this connection type set up, which use an agent to link with our on-premise Oracle database. Od…
-
Async Stored Procedure Call from OIC through Oracle ATP AdapterSummary: Currently, we are having timeout issue (exceeding 240 seconds) when executing a Stored Procedure through ATP Adapter. I don't think there's any problem on the D…
-
ATP Database "Perform operation on table" operation error while invoking the connection errorSummary: I am invoking the Oracle ATP connection in integration, While I select "Perform an operation on a table" I am getting below error: Please help me with the solut…Veera venkata satya Ranga Prasad 18 views 4 comments 0 points Most recent by Veera venkata satya Ranga Prasad Integration
-
REST API Batch Processing To Create Multiple Records not workingSummary REST API Batch Processing To Create Multiple Records not workingContent HI Team, We have ingratiation between EBS(r12) to OEC, we have to do batch processing of …
-
Issue in select statmentSummary: hi When i am trying fetch data from database , i am getting below error. SQL - select xpa.batch_id, xpa.so_number, xpa.org_id from xxmdn_price_adj_tbl xpa where…
-
Efficiently Handling DB Insert/Update Activity in OIC w/ No Response PayloadSummary DB Insert/Update Operations in OIC don't have a RESPONSE Payload confirming if the operation successfully applied to the DB, requiring special handling.Content H…User_2025-02-07-23-59-52-354 198 views 5 comments 0 points Most recent by Biman Dey Sarkar-Oracle Integration
-
Return a json collection from a REST integration involving Oracle DBAdaptorHi All In Oracle 19c I have setup a proc that returns a nested table which references a plsql record. Back in OIC when trying to reference the proc I encountered a 'JCAB…
-
Attaching PDFs to Multiple InvoicesSummary: Content (please ensure you mask any confidential information): Hi all, I am attempting to attach PDFs to multiple invoices (a one to one). The way things are se…
-
Update null value to a table column not working with ATP connectionSummary: Hi Team I'm using ATP connection to update the column value to null, but passing null here is not updating existing value in the table column. How to update any…
-
Sample OIC integration using DB package with plsql table type as in and out parametersSummary: Sample OIC integration using DB package with plsql table type of records as in and out parameters please share the DB package as well Thanks Content (please ens…
-
How to fetch india timezoneSummary: Hi I am trying fetch India time zone instead of UTC but getting error. Can you please help? Content (please ensure you mask any confidential information): Versi…
-
OIC connection to Database VM on CloudSummary Multi tenancy connectionContent Hi All, I have OIC in one Cloud tenant and Oracle databse VM on different Cloud tenant. Both of them are in OCI bit on different …
-
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…
-
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…