Database
Discussion List
-
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…User_2025-02-08-06-30-58-076 45 views 6 comments 0 points Most recent by Rajkiran-Oracle Integration -
Identify OIC connections to ATP database using unexpected database serviceSummary: We have hundreds of OIC flows that connect to our ATP database. We only have 1 OIC connection defined to the database, and it is using the service "_tp". Howeve… -
OIC - Is there any other option apart from agents to connect to on-premise database?Summary: OIC Connectivity option to on-premise database apart from agents Content (please ensure you mask any confidential information): Would like to know if we can use…
-
How to use Bulk Import option in Snowflake adapter in OICSummary: I am trying to load bulk data into Snowflake tables from Fusion using OIC, I see in the documentation we have an option to bulk import data using internal or ex…
-
how to replace schema name in db procedure invocation in OIC GEN3Summary: We have a requirement where the schema name need be changed when we move the code from Non-prod to prod instance. Please let us know how the schema name change …
-
UniversalConnectionPoolException Error for Database Connection on OCI ConsoleSummary: UniversalConnectionPoolException Error for Database Connection on OCI Console Content (please ensure you mask any confidential information): Hi Team, Greetings!… -
What is the best way to sync Oracle Cloud ERP data to Oracle Autonomus DatabaseWe are currently using Oracle Integration Cloud application to integrate other systems with our Oracle Cloud ERP (SaaS) application. In most of the integrations we do ru…Pradeep Moganti 183 views 6 comments 0 points Most recent by Ahmed Samir Abdelnaeim-Oracle Integration
-
issue with stored procedure invocationSummary: We are trying to call a same stored procedure from two different schema.But from one schema it is working fine and from another schema it is failing.Please let …
-
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 17 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 214 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…