In this section, we will see how to hide Quick Action Items in Oracle Fusion Page. Let us consider below Quick Action Items under Procurement section. Here we need to hide Suppliers (New) item Under Procurement. Let us create new sandbox and navigate to Structure. Navigate to Procurement as shown below: Click on Procurement. Click […]
Difference Between File Adapter and FTP Adapter in OIC
Below are differences between File Adapter and FTP Adapter in OIC: File Adapter FTP Adapter File adapter is used to read files from On-premises or private cloud (Private/internal network only (behind firewall)) FTP Adapter is used to read files from Remote FTP/SFTP server. File Adapter Supports below Operation:(A) Read File(B) Write File(C) Delete File(D) List […]
Customer-Trading Party Creation using SOAP API
Follow below SOAP API for creating customer-Trading Party: (A) Create Location: Use Below SOAP API WSDL and Payload to create Location: SOAP WSDL: https://fa-xxx-xxx-saasfaxxx.fa.ocs.oraclecloud.com/foundationParties/LocationService?WSDL Method: https://fa-xxxx-xxx-saasfaxxxx.fa.ocs.oraclecloud.com:443/crmService/FoundationPartiesLocationService Payload: <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/applicationModule/types/” xmlns:loc=”http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/” xmlns:par=”http://xmlns.oracle.com/apps/cdm/foundation/parties/partyService/” xmlns:sour=”http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/sourceSystemRef/” xmlns:loc1=”http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/location/”> <soapenv:Header/> <soapenv:Body> <typ:createLocation> <typ:location> <loc:Country>US</loc:Country> <loc:Address1>1 Test address11</loc:Address1> <loc:City>Columbia</loc:City> <loc:PostalCode>29210</loc:PostalCode> <loc:State>South Carolina</loc:State> <loc:CreatedByModule>HZ_WS</loc:CreatedByModule> </typ:location> </typ:createLocation> </soapenv:Body> </soapenv:Envelope> Location is created now. […]
How to use SELECT AI for Oracle Autonomous Database 23AI
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 […]