Supplier

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_name supplier_name ,SUP.segment1 supplier_number ,ZR.TAX_REGIME_CODE ,ZR.REGISTRATION_NUMBER tax_registration_number ,ZR.EFFECTIVE_FROM…

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 Contact of Suppliers and…

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_sec_attr_values aw, ap_supplier_sites_all assa WHERE aw.web_user_id = FND_GLOBAL.USER_ID AND aw.attribute_code = ‘ICX_SUPPLIER_ORG_ID’ AND assa.vendor_id = aw.number_value AND…

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 assign one or more…

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: SupplierSiteImportTemplate.xlsm Interface Tables: POZ_SUPPLIER_SITES_INT Base Table: POZ_SUPPLIER_SITES_ALL_M Import…

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: SupplierAddressImportTemplate.xlsm Interface Tables: POZ_SUP_ADDRESSES_INT Base Table: HZ_CONTACT_POINTS, HZ_LOCATIONS,…

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_NAME SUPPLIER_NAME ,SUP_SITES.VENDOR_SITE_CODE SUPPLIER_SITE ,(select APT.NAME from apps.AP_TERMS_TL APT where…

Query for Supplier details with banks

SELECT aps.vendor_name|| ‘ ~ ‘|| ass.vendor_site_code “Payee_Identifier” ,accts.ext_bank_account_id “Payee_Bank_Account_Identifier” ,bank.party_name “bank_name” ,branch.bank_branch_name “Branch_Name” ,accts.country_code “account_country_code” ,accts.bank_account_name “Account_Name” ,accts.bank_account_num “Account_Number”…

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’) match_option_suppiers, apssa.vendor_site_id, DECODE(apssa.match_option,’P’,’Purchase Order’,’R’,’Receipt’) match_option_suppier_sites FROM apps.ap_suppliers aps, apps.ap_supplier_sites_all apssa WHERE aps.vendor_id = apssa.vendor_id AND …

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, pv.segment1 supplier_number, plc.description supplier_type, pv.vendor_name supplier_name, …

We take you from best practices to next practices of software implementation

Solutions that Ensure You Stay Ahead of Competition

Your Partner for Strategic Technology Solutions

Guiding Your Digital Transformation Journey