Database
Discussion List
-
How to fetch india timezoneSummary: Hi I am trying fetch India time zone instead of UTC but getting error. Can you please help? Content (please ensure you mask any confidential information): Versi… -
Loading Data to BO from External API using VB Enter EventSummary: We are Loading Data to BO from Oracle Cloud BIP Report using VB Enter Event The No of times we open the page that many times the Data gets loaded to BO . We don… -
Editable table (ADP) how to delete few and modify few records on click of save buttonSummary: Hi Experts I have a editable table in which a user can update, delete, add records to the table, at the end when user clicks on Save button then the details hav…
-
How to export time datatype in excel ?Summary: I am trying to export table data into excel but the column that has time datatype doesn't show in excel
-
How to send the file(image/pdf/word docs) selected using file picker to the backendSummary: I'd like to upload an image, PDF, or Word document through a file picker and then send it to the backend by clicking a button. Right now, I can successfully dis…
-
Data Loaded to BO is not Reflecting on Page ImmediatelySummary: We are fetching the Data from Oracle BIP Report using Page URL Parameter and loading into BO. The Data gets loaded to BO, But the BO data shows on Page on the o…
-
Data Loaded to Business Object from Oracle Cloud BIP ReportSummary: We have Requirement to Fetch the data from Oracle Cloud BIP Report and do the further transactions on a single VB Page. Can anybody Please suggest a suitable So…
-
OIC connection to Database VM on CloudSummary Multi tenancy connectionContent Hi All, I have OIC in one Cloud tenant and Oracle databse VM on different Cloud tenant. Both of them are in OCI bit on different … -
How to make report from data in VBCS ?Summary: I have data calculated inside VBCS and i want to make report with this data
-
Fault Handler for Multiple OperationsSummary: I have the below flow in which 1) First using DB Adapter, selecting rows from database tables using select queries based on where condition 2) Pass the values f…
-
ORDS REST API authentication in VBCS applicationSummary: Hi Experts For development purpose I had tested my ORDS table REST APIs without authentication but for PROD deployment of my VBCS application we are required to…
-
OIC DB Adapter and REST API - LoopingSummary: 1) GetProductInfo is using DB Adapter named 'Product Information' to get all the rows from Oracle database; results are fetched using SQL statement based on the…
-
Is it possible to fetch data from a REST endpoint and save some of its fields in a Business Object?Summary: Integration between a Visual Builder/VB Web Application and HCM REST endpoint. Content (required): We already have the employee/worker data in Oracle HCM and we…
-
DB Adapter reflects new columnSummary DB Adapter DOES Not reflects new columnContent When we add a new column in table, in OIC we have to delete the whole mapper which comes along with the adapter. I…
-
TZ_OFFSET equivalent in xslt?Summary: is there an xslt function equivalent to the sql function TZ_OFFSET Content (required): I'm extremely new to OIC and xsl...I need to find a way to get the timezo…
-
No Backend Match while creating service connectionSummary: Content (required): Hi Experts, I am trying after the new update to create service connection , but I get the message no back end match. The API is from our dat… -
How to call a procedure with parameters in visual builder ?Summary: I have an ATP database and i want to be able to run a procedure in visual builder link it to a button in visual builder
-
How to get total row count of table containing SDP Data ?Summary: I want to display the total row count on the vbcs page. Using SDP.getTotalSize() i am displaying the count on the page. In the SDP totalResults count is differe…
-
How to get started with ORDSSummary: Hi Experts As I'm new to VBCS, our customer is asking to make use of ORDS for database. Could someone please help how to begin with ORDS and test few basic data…
-
I want to connect two databases with each other ?Summary: 1) I have on database is Autonomous Database 2) The second one is normal database that i can access it with VPN I want to connect these two with each other how?
-
Trigger Callback Integration after Custom ESS Job CompleteSummary: Is it possible to trigger a Callback Integration after a Custom ESS Job finishes your execution? Content (required): Hi, For this scenario, we have one custom E…
-
I want to load a lot of data into a table (data will be more than 60000)Summary: I have a business object that has many data i want to load them all into the table. When i did that visual builder freeze and didn't work after it
-
Not able to load/preview certain pages in designerSummary Some pages won't load in designer, although they seem to function when running the web application.Content Situation We've built a web application in Visual Buil…Ronald Konijnenberg 40 views 3 comments 0 points Most recent by Shay Shmeltzer-Oracle Visual Builder
-
How to Hide a Column HeaderSummary: We are fetching the single row Data for only for one field and storing it using SDP and Displaying it in a table. We want to Hide the Header of the Field in the…
-
Populate custom fields on oracle delivered redwood pagesSummary: Populate custom fields on oracle delivered redwood pages. For example: How to populate "person number" on the connections page in about me section? Content (req… -
OIC IBM DB2 Adapter & AS400Summary DB2 AdapterContent Hello All, I understand OIC has a prebuilt IBM DB2 adapter which allows to perform CRUD operations for DB2. However another Document Doc ID 24…
-
Upload CSV File into an Object Storage BucketSummary: We are Pushing he Data from VB into a Bucket by using Object Storage. Can we Upload CSV File into a Bucket Directly. Content (required): Version (include the ve…
-
VB Excel add-in : ORDS service row update fails with Invalid RowIdSummary: A VB excel template is mapped to an ORDS service created on a database table using Auto Rest. While updating some rows through the add-in, the service returns a…
-
How to upload the file with the help of file picker.Summary: I'm following this video and I'm confused while creating the service connection media type selected Image/png but as per my requirement I want to upload any typ… -
Getting Error Code :27040 , when inserting JSON Payload in column using input-text/text-area.Summary: Trying to insert JSON Payload with Length (4421) in a Column with maximum length (32672). Getting Error code: 27040 ,Status :400 Bad Request when inserting the …