Database
Discussion List
-
Error while translating message to the mentioned format.Summary Error creating a stage write and stage readContent I have an integration "App Driven Orchestration" where it starts with a rest adapter that receives a content s…
-
Divide a line every time you find "," to insert into a database.Summary Divide a line every time you find "," to insert into a database.Content I am working on an integration which receives a line similar to this one: 126,12,2007,110…
-
Skip blank lines of a text fileSummary Skip blank lines of a text fileContent Hi everyone, This is my scenario: I have to upload files to UCM, I get the files from an ftp server but I have to validate…
-
How to create a post REST service in OICSummary We have a requirement to create a REST service in OIC. And this service will be exposed to the client to POST their JSON data.Content We have a requirement to cr…
-
Reading application/octet-stream type file output and inserting records into a tableSummary Reading application/octet-stream type file output and inserting records into a tableContent Hi All, I am trying to create an integration in Autonomous Oracle Int…
-
Break the contents of an OIC variable in lines to insert it into a databaseSummary Break the contents of an OIC variable in lines to insert it into a databaseContent Hi everyone, I have created a variable in OIC where it stored the contents of …
-
Pull specific File from Agent server leveraging File AdapterSummary Pull specific File from Agent server leveraging File AdapterContent I am working on two integrations the first one writes a file on a server using the file adapt…
-
Wrapper Packages not getting created properly when using DBAAS AdapterSummary Wrapper Packages not getting created properly when using DBAAS AdapterContent Hello All, I am using DBaaS Adapter to connect to Oracle DBCS (DB System - Oracle D…
-
HDL File upload to UCM not working through OICSummary HDL File upload to UCM not working through OICContent Hi All, I am trying to upload worker.dat HDL file to UCM server through OIC integration. But it is failing …
-
consult database table and repeat a determined process for each value obtained from a specific fieldSummary consult database table and repeat a determined process for each value obtained from a specific field of the table.Content Hi everyone, I am working on a requirem…
-
Unable to get a Response from EBS using rest API In SOAP UI.Summary Unable to get REST URI Response thorough SOAP UI.Content We are deployed PLSQL record type code in EBS as REST API. we are unable to get a response through SOAP …
-
Payload Size Exceeds the LimitContent Hi Team, I am trying to create a scheduled orchestration for populating a Business Object in VBCS through database adapter. However, I am getting the following e…
-
how to get a specific tag values using XpathSummary get a specific tag values using XpathContent Hi All Here I attached XML file for find specific tag using XPath in OIC I am the beginner of XPath. My requirements…
-
Calling SQLLDR from SOA Composite ?Summary Calling SQLLDR from SOA Composite ?Content Please can somewhere share us the way to invoke SQLLDR from SOA Composite, the idea is to load file into stage table u…
-
How to convert Source Json to Target Json In OICSummary Convertion of Source Json to Target Json In OICContent Convertion of Source Json to Target Json In OIC Example Source {"test":"test"} Target {"test1":"test"}
-
Looking for a right tool or product to handle Data ReplicationSummary Data replication or ETL Tool in Cloud ProductsContent Hello All, We are looking into product options which can address the following functionalities : We are loo…
-
The stored procedure invocation only returns the last line of a .dat fileSummary the stored procedure invocation only returns the last line of a .dat fileContent Hello everybody, I am working on an integration which must obtain a .dat file fr…
-
OIC Exception/Error Handling & Recoverable InstanceSummary Oracle Integration Cloud's Exception/Error Handling & Recoverable InstanceContent Hi Team, I have noticed that NOT ALL instances that faulted can be recovered or…
-
Error Calling REST APISummary Having difficulties posting data to Visual builderContent Im attempting to post invoice data to my Visual builder business object. I've used a 3rd party applicat…
-
Pull data from on-premise Oracle DB into PaaS database using DB linkSummary Pull data from on-premise Oracle DB into PaaS database using DB linkContent Hi All, Please advise how to Pull data from an on-premise Oracle DB into Oracle PaaS …
-
Error: While Importing Java jar file in OIC LibrariesSummary I have java code as jar file its not importing in oicContent Hi, I have java code as a jar file for cryptography. While I importing jar file into OIC Library I a…
-
Integration - Database Adapter Polling orderSummary Integration - Database Adapter Polling orderContent Hi All, In which order Database Adapter Polling works? Even though it is using distributed polling and multit…
-
API Specifications for scheduled integrationSummary How to create API Specifications for scheduled integration?Content So I understand how to create API specifications for integrations that start with a REST adapt…
-
ERP and SCM Cloud Data Extracts to on-premise data warehouseSummary Need advice on best option for extract data from ERP/SCM Cloud to on-premise wartehouse. Looked at BI Cloud Connect, but believe that requires a UCM Server on-pr…
-
Integration with HCM Extract Run & Retrieve FlowSummary This is to take note the best practices to observe when integrating OIC with HCM's Extract Run-Retrieve FlowContent Hi Team, I'd like to ask for inputs from the …
-
Is there a way to see response payload using ICS Database?Content Hi All, As per the recommendations we want to disable tracing of the integration(ICS). But if any issues how to debug? Is there a way to see request/response pay…
-
How to pass arguments to DBaas adapter in OIC?Summary How to pass arguments to DBaas adapter in OIC?Content Hi All, We have requirement to pass arguments to the sql query. Below is the sample query. SELECT FNAME, LN…
-
Connecting to OCI(Oracle Cloud Infrastructure) DB from OICSummary Not able to establish connection to OCI DBContent Hi Experts, We have moved from DB classic to DB OCI for database management. The OIC connectivity agent is inst…
-
Problem with Stored Procedure InvokeSummary Unable to invoke Stored Procedure when has Associative Array as inputContent Hi, I am trying to invoke a stored procedure from OIC through DB adapter, the invoke…
-
Runtime Fault/Exception Handling in OIC (Oracle SOA Fault Policy Functionality?)Summary Is Oracle SOA Fault Policy Functionality also present in OIC? Especially handling runtime fault on server sideContent Hello OIC Gurus, Oracle SOA has this Fault …