Blog / Category
Supplier
10 articles in this category
Query to get tax registration at supplier level – Oracle Fusion
The below query extracts the Tax Registration details such as Tax Regime Code, Registration Number of Suppliers from Fusion Applications. SELECT HP.party…
Supplier Contact Import Using FBDI – Oracle Fusion
This blog describes the step by step process of Supplier Contacts migration in Fusion Application using File Based Data Import. Using this process we can create…
How to get supplier ID and supplier site ID for the Isupplier login.
BEGIN SELECT DISTINCT assa.vendor_id,LISTAGG(assa.vendor_site_id, ‘,’) WITHIN GROUP (ORDER BY assa.vendor_id) INTO v_vendor_id,v_vendor_site_id FROM ak_web_user…
Supplier Site Assignment Import Using FBDI – Fusion Applications
This blog describes the step by step process of Supplier Site Assignment migration in Fusion Application using File Based Data Import. Using this process we can…
Supplier Site Import Using FBDI – Fusion Applications
This blog describes the step by step process of Supplier Site migration in Fusion Application using File Based Data Import. FBDI Template: SupplierSiteImportTem…
Supplier Address Import Using FBDI – Fusion Applications
This blog describes the step by step process of Supplier Address migration in Fusion Application using File Based Data Import. FBDI Template: SupplierAddressImp…
Query to find Supplier report with payment method changed date
Introduction: This report will showing all Oracle US and Canada suppliers with payment type of XXX select AP_SUP.SEGMENT1 SUPPLIER_NUMBER ,AP_SUP.VENDOR_…
Query for Supplier details with banks
SELECT aps.vendor_name|| ‘ ~ ‘|| as…
Query to find Suppliers/ Sites with 'Receipt' match option.
SELECT aps.vendor_id, aps.vendor_name, DECODE(aps.match_option,’P’,’Purchase Order’,’R’,’Receipt’) matc…
AP Supplier Banks Payments Query
SELECT pvs.org_id org_id, iep.default_payment_method_code, alc.lookup_code, hou.NAME org_name, pv.vendor_id supplier_id…