Database
Discussion List
-
BO TransactionContent i updating complex list.. But i want start transaction. if it failure i want rollback or commit. Should I use ORDS or BO? ords difficult to use. Table may change…User_2025-02-04-20-31-08-782 17 views 2 comments 0 points Most recent by User_2025-02-04-20-31-08-782 Visual Builder -
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 26 views 3 comments 0 points Most recent by User_2025-08-29-01-25-32-163 Integration
-
oj table data shrinksSummary Data in oj-table shrinks when columns have data of varied lengthContent I have used a table component in our VBCS screen. When the table populates with column da…
-
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 160 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… -
Fetch users who have access to particular application in combo-boxSummary Need to fetch the user names who have access to that particular application and show them in dropdownContent I want to show the user names who have access to my …
-
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…
-
error trying to add integration service connection in VBCSSummary Cant get list of integrations from VBCSContent Was wondering how do I add a service connection to an integration in VBCS .When going through the process of add s…User_2025-02-04-13-35-35-440 37 views 3 comments 0 points Most recent by User_2025-02-04-13-35-35-440 Visual Builder
-
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… -
VBCS Database MonitoringContent Hi All, I know that VBCS comes with a internal database of around 5GB. Is it possible to monitor the size of the internal database as we start using the applicat…User_2025-01-28-05-07-26-222 24 views 1 comment 0 points Most recent by Shay Shmeltzer-Oracle Visual Builder
-
How do I update an entire column with a value?Summary update field entry in visual BuilderContent Hello all!, I have an integration in PaaS that is reading documents that contain refund amounts The refund amounts ar…User_2025-02-04-13-35-35-440 30 views 2 comments 0 points Most recent by User_2025-02-04-13-35-35-440 Visual Builder
-
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
-
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…User_2025-01-29-03-07-51-472 52 views 1 comment 0 points Most recent by Anuj X Maheshwari Integration
-
Recommended Database Objects in VBCSContent Hi Everyone, Working on VBCS I'm using database objects of 10,000 to 50,000 rows and 15 columns. Currently my plan is to use embedded tables but I wanted to ask …User_2025-02-04-12-06-50-154 20 views 1 comment 0 points Most recent by John Ceccarelli Visual Builder
-
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…