Issue: Supplier site not visible from application, but it databse site exists.
Cause: The value in the supplier_notif_method in po_vendor_sites_all table for these problem sites was the word “NULL” instead of being NULL.
Fix is to run below SQL:
UPDATE po_vendor_sites_all
SET supplier_notif_method = NULL
WHERE vendor_site_id =;
Cause: The value in the supplier_notif_method in po_vendor_sites_all table for these problem sites was the word “NULL” instead of being NULL.
Fix is to run below SQL:
UPDATE po_vendor_sites_all
SET supplier_notif_method = NULL
WHERE vendor_site_id =