Database
Discussion List
-
assign oic array to varchar2 field in DBSummary: Hello everyone, help with the following case. I have an integration in OIC that internally invokes a Rest service, this service has a response that contains an … -
OIC Outbound IP - Sufficient & Secure for whitelisting in OCI?Summary: Is OIC Outbound IP sufficient and secure for whitelisting in security rule for access within private subnet? Content (please ensure you mask any confidential in…
-
parameter value is not getting passed to DB adapter in OICgen3Summary: I am invoking an Oracle ATP connection in my integration. I want to fetch IDs from my database table for which I am writing a simple sql query. I have tried thi…Jigyasa Kamthan-Oracle 19 views 2 comments 0 points Most recent by Jigyasa Kamthan-Oracle Integration -
Delete Statement is not Working in Database Adapter In OIC?Summary: We are Tring to Delete Data From Table EX: DELETE FROM table_name Integration is Showing Success but Data is not Deleting From the Table. Content (please ensure…
-
How to insert data in different REST response level to one ATP table in OIC?Hi All, As the following screenshot, I'd like to insert data the REST response data to a ATP table. For this example, the response payload with one parent level 'item' a…
-
Is there a way to change the schema name in OIC integration DB activitySummary: When we want to use a DB activity in Oracle Integration, we need to choose a schema name and a db object. This process would cause a problem when the production…
-
ATP got ORA-00001 when insert sequence in the primary keyHi All, I tried to use sequence to insert data in my table's primary key: I set the increment to 50 after read this document: But when I run the integration it shows 'OR…
-
ATP Adapter or ORDS REST Services: What’s the Optimal Solution for Integrating with OIC?Summary: We are in the process of integrating the Oracle ATP database with OIC to facilitate certain business logics. With the anticipated large data volumes, we are try…
-
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…
-
Best Practice for OIC to Cloud DB: DB Adapter or RESTful Services?Summary Better way to connect in Oracle DBCS from Integration Cloud (OIC/AIC)Content Hi, I'd like to hear your inputs as to which approach is better in terms of efficien… -
OIC Table SchemaHi Everyone, I would like to ask if there's a way to know what is the schema of the table configured in the OIC. Currently modifying an integration and I need to configu…
-
How to pass collections to PL/SQL package from OICSummary: We are in the process of transferring all direct table operations (insert/update/delete) from the OIC database activity to a PL/SQL package. However, we are enc…
-
Fusion - Apex integrationHi Experts, We are using oracle fusion application cloud ERP(SAAS). We also have paas services (OIC4Saas and apex on DBCS) for saas extensions. We wanted to use Oracle F…
-
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…
-
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 123 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 11 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…