Database
Discussion List
-
How data polling mechanism work from Database in OIC By Using Database Adapter as Trigger?Summary: How data polling mechanism work from Database in OIC By Using Database Adapter as Trigger Content (please ensure you mask any confidential information): Version… -
Multiple Email Notify Attachments DamageSummary: The attachments that i get from my ATP database and included in the OIC integration notification action are damaged because of XML tags when use stage write act…
-
OIC db adapter sequencing issue with insert statementSummary: We are using OIC gen 3 (25.04.1) to insert records in atp database. In the db adapter, we are using a sequence. We have noticed that sequence used by the db ada…
-
Oracle DBaaS send query parameters in SELECTHi, I'm trying to send query parameters in my SELECT statement but it keeps returning in syntax error: I have thought we use # to define variables? I let the Query gener…
-
Switch Oracle DBaaS adapter to Oracle ATP via Configuration EditorSummary: We're looking on an initiative to migrate our OIC database connections on existing integrations from DBCS to ATP. In the Integration > Configure section, does t…
-
Met error when using nvl function and parameter in ATP run SQL statementHi All, I have an ATP in OCI using run a SQL statement: When I added the function nvl, it shows error: and there is no error when nvl without parameter: May I know why? …
-
Calling DB Procedure from OIC is taking too much timeCalling DB Procedure from OIC is taking too much time, where as when the procedure is executed independently in the Sql developer it is getting completed within seconds.
-
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 app driven oracle Integration from Oracle database using PLSQLSummary: Our requirement is to trigger oracle integration from our Oracle DBaaS Database. Content (please ensure you mask any confidential information): Version (include…
-
OIC VCN for whitelistingHello all Is there an easy route to know the VCN for OIC for whitelisting ? We are using ATP database with whitelisting hence need the VCN for OIC instance. Thanks -
Not able to update the status of a sales order via REST APISummary Getting Error when trying to update a status of an orrder via rest apiContent Hi , I am trying to change the status of a sales order using a rest api . (EndPoint…
-
Best practice for high volume data transfer via connectivity agent for databaseSummary: Best practice for high volume data transfer via connectivity agent for database Content (please ensure you mask any confidential information): Would like to kno…
-
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 …
-
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 31 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…
-
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…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 …