Showing posts with label Supplier Import Error. Show all posts
Showing posts with label Supplier Import Error. Show all posts

Thursday, 7 November 2013

Supplier Import Error :POS_SPM_CREATE_SUPP_ERR1

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