Why ERP vendor ID is not updated in Supplier Management (SM)?

Cause 1 : Confirmation_out format sent from external system doesn't met the expectation provided in FAQ 183231

Cause 2 : ERP vendor ID received from external system is already exists in SM

Supplier payload (Request_in) generated at SM is successfully processed at external system and the vendor ID is created as expected. It should be sent in confirmation_out payload to have the external ERP vendor ID updated to the respective supplier in SM.

When ERP vendor ID is same as another SM vendor already in the customer site, confirmation_out moved to failed status and has below exception as error message :

org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not

SAP Integration Suite Managed Gateway > Managed Gateway for Sourcing Integration > Managed Gateway for Sourcing Supplier Mgmt