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
This comment has been removed by the author.
ReplyDeleteWe've 2 options for this.
ReplyDelete1) You have to update the vat_registration_num field with .(or eny char) to existing supplier and reinterface new supplier and if customer also there means need to do same for customer also
2) Don't interface vat_registration_num field for new supplier i.e. you can put null while interfacing and update same field after interfaced into application with required value.
if old supplier is inactive then you can update vat_reg_num by adding with _old for both supplier and customer if reqd. if old supplier is active then need to change the value for new supplier.
ReplyDelete