During Supplier Import you may be faced with an error : POS_SPM_CREATE_SUPP_ERR1 . This error is reported if there already exists a record in ap_suppliers/ap_supplier_Sites_All with the same VAT_REGISTRATION_NUM as the current record being errored out.
Oracle does not allow creation of 2 suppliers with the same VAT numbers via supplier import. If needed you can import the suppliers by making these VAT numbers as null and then hard update the Oracle base table column : VAT_REGISTRATION_NUM with the required value,
Thanks
Oracle does not allow creation of 2 suppliers with the same VAT numbers via supplier import. If needed you can import the suppliers by making these VAT numbers as null and then hard update the Oracle base table column : VAT_REGISTRATION_NUM with the required value,
Thanks