14 September 2011

Supplier site not visible from application

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 = ;