Database
Discussion List
-
Oracle DBAAS Connection Error: ORA-12504 - Listener Not Given SID in CONNECT_DATAHi, I'm encountering an issue with our Oracle DBAAS connection. We've got this connection type set up, which use an agent to link with our on-premise Oracle database. Od… -
-
Async Stored Procedure Call from OIC through Oracle ATP AdapterSummary: Currently, we are having timeout issue (exceeding 240 seconds) when executing a Stored Procedure through ATP Adapter. I don't think there's any problem on the D… -
ATP Database "Perform operation on table" operation error while invoking the connection errorSummary: I am invoking the Oracle ATP connection in integration, While I select "Perform an operation on a table" I am getting below error: Please help me with the solut…Veera venkata satya Ranga Prasad 11 views 4 comments 0 points Most recent by Veera venkata satya Ranga Prasad Integration
-
REST API Batch Processing To Create Multiple Records not workingSummary REST API Batch Processing To Create Multiple Records not workingContent HI Team, We have ingratiation between EBS(r12) to OEC, we have to do batch processing of …
-
Rest api in VBCSSummary: Hi I am trying call rest api in vbcs but Not getting expected result. Also attached postman result. Content (please ensure you mask any confidential information…
-
How to combine "Auto populate a table" and "Add a filter criterion" with a Combo Box?Hello! How are you? I have a table in VBCS and it has its values coming from an SDP (that came from a BO). This table auto populate itself with the values from the SDP. …
-
Oracle Visual Builder Database OptionsI'm currently engaged with a client on the development of a couple of apps using Visual Builder. We're exploring various database options as we anticipate that the defau… -
Issue in select statmentSummary: hi When i am trying fetch data from database , i am getting below error. SQL - select xpa.batch_id, xpa.so_number, xpa.org_id from xxmdn_price_adj_tbl xpa where…
-
Efficiently Handling DB Insert/Update Activity in OIC w/ No Response PayloadSummary DB Insert/Update Operations in OIC don't have a RESPONSE Payload confirming if the operation successfully applied to the DB, requiring special handling.Content H…User_2025-02-07-23-59-52-354 226 views 5 comments 0 points Most recent by Biman Dey Sarkar-Oracle Integration -
Scheduling Data Export from a VB AppHas anyone had experience implementing scheduled exports of data from a VB app with an embedded database or BYODb? Just wondering whether there is an option to schedule …
-
Return a json collection from a REST integration involving Oracle DBAdaptorHi All In Oracle 19c I have setup a proc that returns a nested table which references a plsql record. Back in OIC when trying to reference the proc I encountered a 'JCAB…
-
Published App: how to see the data of BO's after publishing the applicationSummary: Hi Experts, I have published applications use BO (the Embedded database). From where I can check the data saved in the embedded data base as GUI. Content (pleas… -
Attaching PDFs to Multiple InvoicesSummary: Content (please ensure you mask any confidential information): Hi all, I am attempting to attach PDFs to multiple invoices (a one to one). The way things are se… -
Export data to predefined excel template from vbcs page oracleSummary: I am working on a custom client requirement on VBCS page development. In page there is a table where data is coming from ATP DB. I need a functionality to expor…
-
Update null value to a table column not working with ATP connectionSummary: Hi Team I'm using ATP connection to update the column value to null, but passing null here is not updating existing value in the table column. How to update any…
-
connection error to an ATP Database via VBCS Application in OICSummary: connection error to an ATP Database via VBCS Application in OIC Content (please ensure you mask any confidential information): Hi Team, Greetings! we are trying… -
VBCS EXCEL Plug In PUT operation for child component not working with ORDS Manually Created ModuleSummary: VBCS EXCEL Plug In PUT operation for child component not working with ORDS Manually Created Module Content (please ensure you mask any confidential information)…
-
How to show/hide a region conditionally on basis of a value in business object in VBCS pageSummary: The VBCS page is having list view component (card layout). There is a custom client requirement: depending on a value of a field in the business object used for…
-
Verify data with POST method in VBCS.Hello Everyone! I was trying to do a logic that a user can only proceed to a certain page if he put some values (that is already stored on Business Object) on a form. Si…
-
visual builder in oic v3 use atp instance in private subnet vcnSummary:visual builder in oic v3 use atp instance in private subnet vcn Content (please ensure you mask any confidential information): Hello, I wanted to ask if in OIC v… -
Calling BO using JS to filter dataSummary: I have a BO for booking with field of startDate and endDate and a few other field. For now the filtering process is based on a few chosen criteria which is star…
-
Sum Total and Average of SDP table Column dataSummary: We have a SDP table data We need to fetch the average of one column named Rank as Average Rank = Sum Total of Ranks/ # of Ranks for each Employee Please advise …
-
Is it possible to switch from inbuilt schema to "Bring Your Own Schema" later?Summary: While an application was being developed in VBCS, this feature came out. Visual Builder on Existing Oracle Database with Business Object We decided to Go Live w…
-
Creating a simple "user registration" app is giving me ERROR 415Hello everyone! I'm trying to create a simples POST on my Business Object and I'm getting ERROR 415 - Unsupported Media Type. When I click on the "save" button nothing h…
-
Business Object - Composite primary keySummary: Can we define a composite primary key for a business object in Visual Builder? Content (please ensure you mask any confidential information): In my database obj… -
How to Upload a Custom Excel sheet to Page and Download the Same Uploaded Excel SheetSummary: How to Upload a Custom Excel sheet to Page and also Download the Same Uploaded Excel Sheet Can any body Please share an example for this Content (please ensure …
-
Sample OIC integration using DB package with plsql table type as in and out parametersSummary: Sample OIC integration using DB package with plsql table type of records as in and out parameters please share the DB package as well Thanks Content (please ens…
-
is it possible to npm install in visual builder?Summary: Hello, I want to connect to oracle database with node js "oracledb" dependency. is it possible to achieve this in VBCS. Please guide me with the steps to achiev…
-
is it possible to use ORDS apis in exadata database running in OCI ?Summary: Hi Experts is it possible to use ORDS apis in Exadata database running in OCI in our visual builder application ? @Sherif Bashar @Nada Bashar Content (please en…