In this post, we will see how to use SELECT AI for Oracle Autonomous Database in 23AI. SELECT AI is a new feature introduced in Oracle Database 23ai (formerly Oracle Database 23c) that integrates natural language processing (NLP) directly into SQL, enabling users to query the database using plain English or other natural languages. SELECT […]
How to Provision ATP database in Oracle Cloud Infrastructure (OCI)
In this section, we will see how to provision ATP database in Oracle cloud infrastructure (OCI). We need to follow below steps to create ATP database in OCI. Login to your OCI account. Go to Navigation Menu —>Oracle Database —–>Autonomous Database Click on Create Autonomous Database. Provide required details. Provide ADMIN credentials as shown above. […]
How to resolve VB Studio Error-You are not a member of this organization in Oracle Fusion
How to resolve VB Studio Error- “You are not a member of this organization” in Oracle Fusion. When we try to open VB Studio from Configuration –>Visual Builder in oracle fusion, we usually get error as “You are not a member of this organization” in Oracle Fusion. In this post, we will see how to […]
Query to Get Supplier Tax Payer ID
/* Query to Get Supplier Tax Payer ID */ select HP.PARTY_NAME VENDOR_NAME, PS.SEGMENT1 VENDOR_NUMBER, PSP.ORGANIZATION_TYPE, PSP.INCOME_TAX_ID, PSP.VAT_REGISTRATION_NUM, PSP.CREATED_BY, PSP.CREATION_DATE from POZ_SUPPLIERS_PII PSP, POZ_SUPPLIERS PS, HZ_PARTIES HP where PSP.VENDOR_ID=PS.VENDOR_ID and PS.PARTY_ID=HP.PARTY_ID
REST API to End Date Supplier and Supplier Site Bank Assignment in Oracle Fusion
Supplier and Supplier Site Bank account assignment can be end dated using below REST API in oracle Fusion. Step1: Get INSTRUMENT_PAYMENT_USE_ID for Supplier/ Supplier Sites level. Run below SQL queries to get INSTRUMENT_PAYMENT_USE_ID for Supplier and Supplier Site level. Supplier: SELECT DISTINCT APS.SEGMENT1, IPIUA.INSTRUMENT_PAYMENT_USE_ID FROM POZ_SUPPLIERS_V APS, IBY_EXTERNAL_PAYEES_ALL IEPA, IBY_EXT_PARTY_PMT_MTHDS PMTMTHDS, IBY_PMT_INSTR_USES_ALL IPIUA, IBY_EXT_BANK_ACCOUNTS IEBA […]
Customize Fetch Action Chain in VBCS
In Oracle Visual Builder Cloud Service (VBCS), a Customize Fetch Action for an SDP (Service Data Provider) is a way to override the default data fetching behavior and write custom logic (typically JavaScript) to control how and what data the SDP retrieves from a service or other sources. In this post, we will see how […]
Difference Between Select (Single) and Combo-Box in VBCS
In Oracle Visual Builder Cloud Service (VBCS), both Select (Single) and Combo Box components allow users to choose a single item from a list. However, they differ in terms of features, usability, and flexibility. Here’s a detailed comparison: Feature Select (Single) Combo Box User Selection Only allows selection from the pre-defined list Allows selection from […]
Multiple fields for Select (Single) in VBCS
Multiple fields for Single select in VBCS In this post, we will see how to display multiple fields in Select (Single) in VBCS application. When we use Select (Single) component in VBCS, it usually shows only one field in select list. But we can show multiple fields in select list also. Step1: Create VBCS Web […]
What is Shell Page in VBCS?
Shell page in VBCS plays a very important role in structuring the layout and navigation of web applications. It acts like a master layout or template that wraps your application’s individual pages and manages consistent UI element across all pages. Each web app created in VBCS has one shell page which can be found under […]
How to Create Dialog Box and Display Data from Fusion REST API in VBCS
How to Create Dialog Box and Display Data from Fusion REST API in VBCS In VBCS, a dialog box is usually used to display additional information, forms or confirmations messages without navigating away from the current page. In this post, we will see how to configure dialog box in VBCS. Requirement: We have VBCS Page […]