Database
Discussion List
-
Send JSON Data prepared in a module function to PL/SQL procedureContent Hi, There is a requirement to pass json type data to pl/sql procedure. Currently, we are passing json after stringify and then replacing " with \". Since just do…User_2025-02-06-05-53-15-083 42 views 2 comments 0 points Most recent by User_2025-02-06-05-53-15-083 Visual Builder -
Getting error while querying Custom Object fields using Rest APISummary Getting error while querying Custom Object fields using Rest APIContent I am trying to query an attribute by using dynamic URL parameter as shown in the link bel… -
Invoice Extraction using EBSSummary What are the ways Invoice can be extracted using EBS in OICContent What are the ways Invoice can be extracted using EBS in OIC. i know using Business event is an… -
Insert data to database using VBCS excel PluginSummary VBCS excel PluginContent Hi Experts, We have a requirement to insert data into database using excel(used by users). I am evaluating the option of using VBCS exce…User_2025-02-05-11-44-44-738 61 views 3 comments 0 points Most recent by Alex D-Oracle Visual Builder
-
Capture values in comma separated, selected from Select Many ComponentContent Hi, I am using a Select Many Component to select multiple values from LOV listed from Rest. Now i wanted to store the selected values in custom table with comma …User_2025-02-05-15-08-54-217 24 views 1 comment 0 points Most recent by Duncan Mills-Oracle Visual Builder
-
Read File in Segments to REST Service insert to ATP databaseSummary Read File in Segments to REST Service insert to database results in all rows written in each segment readContent I have a very large file to import to my integra…User_2025-02-05-14-51-55-798 59 views 6 comments 0 points Most recent by User_2025-02-05-14-51-55-798 Integration
-
Perform On Table - Select operation is not working as expectedSummary Perform On Table - Select operation is not working as expectedContent Hi , I am trying to fetch data from two tables. I am doing it with "Perform operation on ta…
-
Security questions on VB and DBCS connectivitySummary Security questions on VB and DBCS connectivityContent We are planning to use the new feature VBCS to add tenant database on external DBaaS. We had the below ques…
-
JCS-SaaS Extension / APEX DB Connectivity from Java using JNDISummary JCS-SaaS Extension / APEX DB Connectivity from Java using JNDIContent Hello, I am trying to connect to JCS-SaaS extension/APEX DB from a Java program using JNDI.…
-
Best approach to expose custom database objects/functionality as Rest service, to consume in VBCSSummary Best approach to expose custom database objects/functionality as Rest service, to consume in VBCSContent Experts, We need your help in identifying the best optio… -
How to join two tables in vbcs?Content How to create realationship in BO between two Tables. For example: I have two tables. Employee Table. Primary Key: Request_Num Course Reference Table. Foreign Ke…User_2025-02-05-07-12-25-853 155 views 5 comments 0 points Most recent by Shay Shmeltzer-Oracle Visual Builder
-
What's the difference of "For Each" action and adding for-each during mappingContent Hi experts, In integration we are reading one file which has multiple lines, after that we want to call a DB procedure for each line(line value as input paramete…
-
Oracle DBaaS Adopter to ATP Adopter MigrationSummary Oracle DBaaS Adopter to ATP Adopter MigrationContent Hi All, We are in the process of Upgrading the Classic Database to ATP Cloud Service. In this DB, we have an…User_2025-01-31-15-27-19-928 47 views 10 comments 2 points Most recent by User_2025-01-31-15-27-19-928 Integration
-
Using Integration Service with Azure and AwsSummary Connectivity with Azure and AWS with Oracle Integration CloudContent My customer is interested to Integration Service. They are considering to implement datalake…
-
Remove trailing zerosSummary Remove trailing zeros of numberContent Hi, I have my input text as 0000001780936400. I should remove leading and trailing zeros in the number and the result shou…
-
How to load overtime information into Oracle HCM?Summary How to load overtime information into Oracle HCM?Content Hi Everyone, I have a requirement to load overtime information of an employee from a 3rd party system to…
-
Error Creating Connection for Oracle DBCSContent Hi All, Can you please guide me how to create a connection for Oracle Database Connection with DBCS. PFA Screenshot of the details entered while creating connect…
-
Search Criteria for particular user?Content Hi, We have developed an application in vbcs When logged into the application using username and password in which we get details related to that employee We use…User_2025-02-05-07-00-39-312 30 views 5 comments 0 points Most recent by Shay Shmeltzer-Oracle Visual Builder
-
Accessing Integration User Name in OrchestartionSummary Logged in user infromationContent Hi, Use Case: In ad-hoc run of scheduled integration I am populating a Database table and I also want to populate the username …User_2025-02-05-11-44-44-738 43 views 9 comments 1 point Most recent by User_2025-02-05-11-44-44-738 Integration
-
OIC Agent Installation - UnknownHostException from DbaaS serverSummary OIC Agent Installation - UnknownHostException from DbaaS serverContent We had followed https://docs.oracle.com/en/cloud/paas/integration-cloud/integrations-user/…
-
IntegrationContent I have to update the a staging table with the values from the input file. I have to run the following query in AIC. UPDATE staging_table SET active_flag = :activ…User_2025-02-05-09-32-34-013 35 views 3 comments 0 points Most recent by User_2025-02-05-09-32-34-013 Integration
-
Internal server error 500 when creating a complex business object using REST callSummary Internal server error 500 when creating a complex business object using REST call.Content Goal We would like to store a page variable, whose type is based on the…
-
Whether VBCS can pull from any of database?Summary Can we build custom form based on database data?Content Would like to understand whether we can build custom application based on data resides in Database like O… -
WSDL generate in VBCS application?Content Hi Team, We have developed an application in VBCS, in which we have business objects and we need to generate wsdl using that business objects data. How to achiev…User_2025-01-31-15-10-49-714 30 views 3 comments 0 points Most recent by Duncan Mills-Oracle Visual Builder
-
OIC Timeout connecting to Database on CloudSummary OIC Timeout connecting to Database on CloudContent Hi All, I have heard new DB adapter is being rolled out that won't need an agent to be installed on Cloud DB, …User_2025-02-05-11-44-44-738 20 views 0 comments 2 points Most recent by User_2025-02-05-11-44-44-738 Integration
-
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 download uploaded file in button action?Content Hi All, We have file upload functionality in our VBCS page. Uploaded file will be of in any format i.e (PDF, txt, Document, excel, image etc.) we show that file …User_2025-02-05-07-00-39-312 65 views 4 comments 0 points Most recent by Duncan Mills-Oracle Visual Builder
-
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 12 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 57 views 12 comments 0 points Most recent by User_2025-01-31-15-27-19-928 Integration