Database
Discussion List
-
Integration ApporachContent Hi, Our customer have DB Cloud, OIC (Oracle Integration Cloud), JCS (Java Cloud Service) and Fusion Cloud (SaaS). We have tried to integrate the third party syst… -
How to catch the error message in response of Fault DetailsSummary How to catch the error message in response of Fault DetailsContent Hi All, I had an unhandled error in one of my integration. Please see the highlighted in my at…User_2025-02-04-13-12-58-802 11 views 2 comments 0 points Most recent by User_2025-02-04-13-12-58-802 Integration -
how to update database with the database adapter?Summary need to update rows based on a value found in one of the fieldsContent Hello Gurus, I'm processing data from a database using the DB adapter. I'm able to get dat…User_2025-02-04-13-35-35-440 18 views 2 comments 0 points Most recent by User_2025-02-04-13-35-35-440 Integration
-
DBCS - ConnectionContent Hi, We have tried to connect the Oracle Database Cloud Service using 'Oracle Database' adapter. But it is error out. How to create connection for DBCS. Thanks, M…Mohana Gopal S-Oracle 38 views 12 comments 0 points Most recent by User_2025-01-31-15-27-19-928 Integration
-
Run a select clause in ATP database with 'in' Operator using OIC ATP AdapterSummary Run a select clause in ATP database with 'in' Operator using OIC ATP AdapterContent Hi, RestAPI structure : { 'accountNum' : '123456' 'product' : ['abc','def','g… -
Run a select clause in ATP database with 'in' Operator using OIC ATP AdapterSummary Run a select clause in ATP database with 'in' Operator using OIC ATP AdapterContent Hi, RestAPI structure : { 'accountNum' : '123456' 'product' : ['abc','def','g…
-
Connecting Oracle Integration to Oracle ATP - Issue with SequencingSummary I am not able to understand from where the sequence is picked up.Content In Oracle ATP DB : Created new sequence CREATE SEQUENCE ZEB_TEMP START WITH 1000000 INCR…
-
Oracle DbaaS Test Connect Failure in ICSSummary ICS Test DbaaS Connection failing after updating the schema passwordContent A number of integrations in ICS using a Oracle DbaaS Connection. The connection was c…
-
How to move IAR file from one OIC to Another OIC instanceSummary Move IAR file from one OIC to Another OIC instancContent I have Export the IAR file from One OIC Instance. 1. Is it IAR having All the dependencies like lookups …
-
Load data from Microsoft Sql server to Oracle cloud Paas using Web servicesSummary Load data from Microsoft Sql server to Oracle cloud Paas using Web servicesContent Hi, Can anyone please guide me, Is it possible to automate a process to direct…User_2025-02-05-00-15-45-904 14 views 0 comments 0 points Most recent by User_2025-02-05-00-15-45-904 Integration
-
Connect Oracle cloud Database service with Microsoft sql server without Oracle Integration Cloud tooSummary Connect Oracle cloud Database service with Microsoft sql server without Oracle Integration Cloud toolContent Hi, Good day! Need help in connectivity We have crea…User_2025-02-05-00-15-45-904 30 views 0 comments 0 points Most recent by User_2025-02-05-00-15-45-904 Integration
-
Facing issue while reading EDI filesSummary unable to read the file contents of edi filesContent Hi, I am trying read IGM/EGM EDI Files in OIC and tried multiple ways to read by creating NXSD by uploading …Abhinav Prasoon-157527 45 views 0 comments 0 points Most recent by Abhinav Prasoon-157527 Integration
-
XSLT transformationSummary Select a distinct value from a DB resultset arrayContent Hi Folks, Our requirement is to read data from a MS SQL server DB and transform to fusion FBDI templates…Raghavendra Manchigiah-109808 49 views 3 comments 0 points Most recent by Kanchankumar Khedkar Integration -
Compare if a Select query returns data.Summary Compare if a Select query returns data.Content Hi everyoe, I am working on an integration where I must evaluate a condition, first I need to do an operation 'sel…
-
Multiple rows are not updating in database using ICS adapterSummary Multiple rows are not updating in database using ICS adapterContent Issue while updating multiple rows in the database: #1: I have selected 'Update' operation in…
-
Error using stage file with the action: Zip FilesSummary Error using stage file with the action: Zip FilesContent I'm working on an integration that reads a list of files and for each one generates a .dat file and comp…
-
Different ways to generate an APISummary Is there any other way to generate an API?Content Hi Experts, Besides creating a Plan and use its API, is there any other way to generate an API to consume the D… -
Retry count / Interval in DB adaptersSummary Retry count / Interval in DB adaptersContent Hi, In case of a remote fault, do we have a mechanism to retry the DB insert/Select ? Like we do in SOA or OSB ?. I …User_2025-01-31-16-03-44-491 34 views 6 comments 0 points Most recent by Hemanth Lakkaraju-Oracle Integration
-
Integration UsecaseSummary OnPrem DB to Fusion integrationContent Dear Experts, We are evaluating PaaS offerings to implement the following Integration use case : Integrate transactional d…Raghavendra Manchigiah-109385 26 views 0 comments 0 points Most recent by Raghavendra Manchigiah-109385 Integration
-
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…User_2025-08-29-01-25-32-163 30 views 3 comments 0 points Most recent by User_2025-08-29-01-25-32-163 Integration
-
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 …User_2025-02-04-13-12-58-802 145 views 11 comments 0 points Most recent by User_2025-02-04-13-12-58-802 Integration
-
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 …