Database
Discussion List
-
Application ArchitectureSummary: More of a general question about application archtitecture. Is there a best practice guide when it comes to application architecture? Let explain what I am tryi… -
Sort column when download the data in visual builder templateSummary: Hi, Is there a way to sort the column when we download data? I do the column sort and save the file. When I do the download data next time, the sorting will rem… -
is there any free limit for the OCI object storage that we can consume in oracle vbcsI wanted to utilise the object storage for storing image files in oracle vbcs , so can i use the oci's free limit or need to buy a storage
-
View BLOB Image in Image ComponentSummary: I have a REST API hosted in Oracle ORDS which is giving me an image in response (source type = Media Resource). Below is a sample query SELECT image_content_typ…
-
Issue saving data to BOSummary: While trying to Save Data to a BO using SDP . It is saving as 0 1 2 3 etc. The Field Name is Emp_Dept_Name which has data like 'HR', IT ', etc. It is selected t… -
How to Show the Table Data Just Besides the Input Text Box as PopupSummary: We have a Requirement to show the Tabel data just besides the Input Text box The Data is getting Populated to the Input Text box based on Table First Selection …
-
Oracle VBCS: Creating Business objects from more than 1 schema in Oracle visual builder applicationHi All, We have 2 schema created in our ATP DB. and we wanted to created Business Object for our application using both the schemas. But what I observed is that once I c…
-
Using API gateway instead of directly calling ORDS APISummary: Hi Experts I have a requirement to call ORDS API via API gateway instead of directly calling from visual builder application. Is this possible? Any solution on …
-
REST APII have two tables named attendance_device_user and attendance_device_missing_punch. Legal entity defined for all user in attendance_device_user table. What I wish to ach… -
When leveraging existing table in VBCS, how to create composite key in Business Object ?Summary: Not able to create a composite key on existing table in Business Object. Need to maintain unique values in 2 columns, so created composite key constraint in the…
-
Realtime use cases for business objectSummary: Realtime use cases for business object Content (please ensure you mask any confidential information): Hi Expert, How we can leverage Business object in VBCS in … -
How to show date and time based on user zoneSummary: How to show date and time based on user zone Content (please ensure you mask any confidential information): Hi Expert, we have a date field where we are display…
-
How to connect to private database from VBCSSummary: How to connect to private database from VBCS Content (please ensure you mask any confidential information): Hello Expert, We have a VBCS application where we ar…
-
What is the best approach to insert report data from oracle fusion to Autonomous DB?Summary: Hello, I am trying to insert the data from a report whose output is in XML format using OIC in which SOAP service is called to retrieve data from report and pas… -
Which one is better in terms of cost Oracle apex or Oracle VBCSSummary: Which one is better in terms of cost Oracle apex or Oracle VBCS Content (please ensure you mask any confidential information): Which one is better in terms of c…
-
VB schemas on ATPSummary: hi, we have one DV and one Live deployment … we are running VB on the ATP database … on the ATP db, we find there's over 80 vb_vb_xxxxx schemas … should we remo…
-
Cannot Publish, the Deploy fails with Errors ORA-00955, ORA-00904Summary: hi, we have a vb standalone app running on ATP, already published as Live. Now when we try to publish again, the deployment fails with messages relating to BO's…
-
Not able to Create/Access Business ObjectsSummary: From Oracle Cloud Applications Configuration →Visual Builder Created an Empty Project and then Created a space by selecting New Visual Application and created t…
-
Visual Builder Studio unable to create business objects from tenant database and csvSummary: I keep getting an error in my attempt to create business objects from my tenant database and local CSV files Content (please ensure you mask any confidential in… -
Recommended option to connect to ATP DB from VBCS - Tenant DB or ORDSHi Team, We are using VBCS(comes with OIC) for building some complex UI extension. As the volume of data would be high, we'll be using ATP DB connectivity to store the d…
-
How to analyze the "SQLN_EXPLAIN_PLAN" warning in VBCS?Summary: Content (please ensure you mask any confidential information): I need help with the following warning when creating a new version of an App in VBCS I am migrati… -
Retrieve Database Sequence Next value in VBCSSummary: Hi experts, How to get the sequence.nextval in VBCS and display it in user interface where sequence has been stored in ATP DB. Use case: When multiple users acc…
-
Gen3: vbcs --> atp service connection failing with 403 ACL issue.Hi, Below is the error we are seeing while accessing ATP ORDS service from VBCS gen3 instance. This was working fine in VBCS Gen2. "type": "abcs://proxy_problem/oauth/au…
-
bulk uploadSummary: How can we bulk upload data from an excel. Content (please ensure you mask any confidential information): Version (include the version you are using, if applica…
-
After 24.10 update, BOs don't honour the default sort order of the underlying DB View/TableSummary: We have noticed that after 24.10 update, Business Objects don't honour the default sort order of the underlying DB View/Table Has anyone else noticed this latel…
-
Optimizing Performance in VB BO for Large DatasetsSummary: Content: Hi Expert, I have a table with 6 million records. When I run a “SELECT * FROM” statement in SQL Developer, it executes very quickly, within a few secon…
-
CRUD operation on ADP on save to reflect in BOSummary: I have an ADP which has to be inserted in a BO based on ATP table(Custom VBCS BO). The ADP has some columns which is there in specified BO as well (ADP in not b…
-
How to develop a BIP / OTBI report to fetch details from VBCS pageSummary: Hi Team, We have a customized VBCS page for Inventory transactions. Our requirement is to develop a BIP / OTBI report to fetch details from the VBCS page. Is it…
-
Is ORDS supported by Oracle to use with OIC-VB?Summary: Please, Oracle teams. Is ORDS supported by Oracle to use with OIC-VB? We are planning to do some screens VB to use ORDS. Some of the tables has clob. content, w…
-
Getting an error while trying to get value from parent BO's Attribute in Before Insert TriggerSummary: I am using Before Insert trigger, in which trying to get the value of BO' attribute. Content (please ensure you mask any confidential information): For example,…