Database
Discussion List
-
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 31 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 44 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 48 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… -
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 129 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 …
-
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…User_2025-02-04-13-35-35-440 24 views 1 comment 0 points Most recent by User_2025-02-04-13-35-35-440 Integration
-
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 …User_2025-02-04-13-12-58-802 10 views 2 comments 0 points Most recent by User_2025-02-04-13-12-58-802 Integration