/* 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 […]
How to add Icon/Logo to Button in VBCS
In this post, we will see how to add Icon/Logo to Button in VBCS. Let us create a Page with Button in VBCS as shown below: Also set Chroming property of Button as “Call To Action”. We will add download Icon to this button. Click on StartIcon property. Select Icon. Click on Icon (File-Image). Replace […]
Button Chroming in VBCS
In Oracle Visual Builder Cloud Service (VBCS), the “Chroming” property for a Button controls the visual style or appearance of the button — essentially how it looks in terms of emphasis and display priority. Common Chroming Options in VBCS Buttons: (A) Borderless: Button without border or background — minimal styling. Low emphasis. (B) Call To […]
Configure Implementation and Employee User in Oracle Fusion
For any Oracle Fusion implementation project, we usually create two types of users: Let us check in details regarding each type of user and how to create these users: 1.Implementation User: Implementation users are those users who are implementing system. These are IT consultants who are working on implementation. These users are not actual employee […]