Database
Discussion List
-
How to use conditional compound filter for below criteria: Service Data Provider (on table)Summary How to use conditional compound filter for below criteria: Source: Service Data Provider (on table)Content How to use conditional compound filter for below crite…User_2025-02-01-05-31-49-271 70 views 25 comments 0 points Most recent by Shay Shmeltzer-Oracle Visual Builder -
How to pass arguments to DBaas adapter in OIC?Summary How to pass arguments to DBaas adapter in OIC?Content Hi All, We have requirement to pass arguments to the sql query. Below is the sample query. SELECT FNAME, LN…User_2025-01-31-15-33-33-933 265 views 8 comments 1 point Most recent by User_2025-01-31-15-33-33-933 Integration
-
How to use aggregate and groupby clause for reporting in VBCS.Summary How to use aggregate and groupby clause for reporting in VBCS.Content How to use aggregate and group by clause for reporting in VBCS. Business Scenario: We have …User_2025-02-01-05-31-49-271 39 views 4 comments 0 points Most recent by Shay Shmeltzer-Oracle Visual Builder
-
How we can use date time converter to load correct date time in User Interface from data object?Summary How we can use date time converter to load correct date time in User Interface from data object?Content Q1: We are getting wrong time displayed on UI when using …User_2025-02-01-05-31-49-271 66 views 15 comments 0 points Most recent by User_2025-01-31-15-40-56-878 Visual Builder
-
Connecting to OCI(Oracle Cloud Infrastructure) DB from OICSummary Not able to establish connection to OCI DBContent Hi Experts, We have moved from DB classic to DB OCI for database management. The OIC connectivity agent is inst… -
Performance IssuesSummary Performance IssuesContent Hi All, In the last month or so I'm building an app using Visual Builder. Lately, as the app grows, I encounter with heavy performance … -
Composite KeySummary Composite KeyContent Hello, How do we make 2 columns combine as a composite key at the VBCS Object level.Currently there is only Unique feature.User_2025-02-01-05-31-49-271 24 views 8 comments 0 points Most recent by User_2025-02-01-05-31-49-271 Visual Builder
-
Where NOT EXISTS QuerySummary Is it possible to perform the equivalent of a Correlated sub-query using RESTContent Is it possible to write a query like this in VBCS? SELECT * FROM TABLE_1 t1 …
-
Creating HCM Extensions with JCSSummaryCan we use JCS instead of JCS-SX to create extensions for Oracle HCM Cloud? ContentWe are in the process of evaluating options for creating extensions to the HCM …
-
Q: How to filter ArrayDataProvider?Summary How to filter a table based on ADP?Content Hi All, I created an editable table based on ArrayDataProvider. How can I filter the table, let's say, using a paramet…
-
Problem with Stored Procedure InvokeSummary Unable to invoke Stored Procedure when has Associative Array as inputContent Hi, I am trying to invoke a stored procedure from OIC through DB adapter, the invoke…
-
REST endpoint viewer not workingSummary The REST Endpoint viewer for business objects in not working as documentedContent I am going through his document. https://docs.oracle.com/en/cloud/paas/app-buil…
-
How to do a batch request for parent and child (Both parent and child - NEW)Summary How to do a batch request for parent and child (Both parent and child - NEW)Content How to do a batch request for parent and child (Both parent and child - NEW) …User_2025-02-01-05-31-49-271 34 views 2 comments 0 points Most recent by User_2025-02-01-05-31-49-271 Visual Builder
-
Updating the VBCS internal database through APIs?Content Hi As part of an integration project with OIC I am looking for way to create a custom monitoring application which would be more user friendly than the built-in …User_2025-02-03-21-18-19-063 20 views 2 comments 0 points Most recent by User_2025-02-03-21-18-19-063 Visual Builder
-
Runtime Fault/Exception Handling in OIC (Oracle SOA Fault Policy Functionality?)Summary Is Oracle SOA Fault Policy Functionality also present in OIC? Especially handling runtime fault on server sideContent Hello OIC Gurus, Oracle SOA has this Fault … -
Can we Poll a table by considering more than one column flag using DB AdapterSummary I want to poll a table by checking two column flag values. Is that possible in ICS?Version 18.3.3.0.0User_2025-01-29-03-07-51-472 5 views 3 comments 0 points Most recent by Nagireddy Tadi-Oracle Integration
-
Issue Activating ICS Integration - DB Adpater IssueSummary Facing Issue while Activating ICS Integration with DB adapter configured.Content We are now facing issue in activating and ICS integration with DB adapter. I'll …
-
Retrieve SOA-MDS passwordSummary How to retrieve the SOA-MDS password and configure the db based MDS connection from jdeveloperContent We created a SOA instance and corresponding database instan…
-
Creating business obect from table creation sql scriptsContent HI All, We are using vbcs as part of Autonomous OIC. One thing we have learnt is that the underlying database is not accessible using sqldeveloper. Now in order …
-
Checkbox with multiple values needs to be added to the business objectContent I have a checkbox which can have multiple values selected. I need the values selected to go into a field in the business Object, What should be the type of the f…
-
Does OIC have data warehouse features?Summary Does OIC have data warehouse features?Content We need to be able to archive files from source locations. Does OIC have any archival or data warehouse features?
-
Downtime Handling in OICSummary We encountered intermittent connection (2-3 minutes of random downtime) in OICContent Hi, We encountered intermittent connection (2-3 minutes of random downtime …
-
Custom SQL queries against Cloud ERP via OAICSSummary Custom SQL queries against Cloud ERP via OAICSContent Hi All, I am building an integration in OAICS, based on (I expect a common scenario) where we are creating …User_2025-01-30-19-13-07-190 43 views 2 comments 1 point Most recent by User_2025-01-30-19-13-07-190 Integration
-
Limit on the size of data in Business Objects in VBCS application.Content Hi Team, We are planning to build the VBCS application which will store third-party payable invoices for fusion application. Users will perform necessary data co…Dipak Chhablani-Oracle 176 views 1 comment 1 point Most recent by Shay Shmeltzer-Oracle Visual Builder
-
Select statement with DB2 connector doesn't return anything to mapSummary Using the DB2 connector to connect to DB2 over port 446, select statement validates and generates and xsd but there is not outbound mapping.Content I administer …User_2025-01-31-15-40-56-878 52 views 8 comments 2 points Most recent by User_2025-01-31-15-40-56-878 Integration
-
JCS-SX:IS Reporting Feature (similar to BI or any alternative) present in JCS-SX?Summary JCS-SX:IS Reporting Feature (similar to BI or any alternative) present in JCS-SX?Content Hi, This query is in relation to the JCS-SX and its corresponding DBCS. … -
Performance on LOV's using external DB call (VBCS)Summary Call DB to populate list of valuesContent We are trying to populate list of value for the PO field from the DB, but we are having performance issue and the list …
-
ICS: Agent not showing in DB Connection Agent Confguration after installing the On-Premise AgentSummary The agent is not showing in the 'Configure Agents' interface when doing DB Connection setup in ICSContent Hi, We are using ICS Standard Edition, Version: 18.2.3.…
-
Connection Timeout in REST adapterContent Hi, I have a use case where I have to insert the data from BI report into the database. I have exposed the data insertion as REST service using ORDS. In some cas…
-
Is there any direct connectivity to connect the tables in VBCS to a DB?Summary Is there any direct connectivity to connect the tables in VBCS to a DB?Content I'm trying to create a Web APP in Oracle Cloud Visual Builder. I could able to dev…