Symptom
When you try to use Upsert in Data Workbench to change the existing Employee Responsible - Sales, either system create a new Employee Responsible - Sales or system throws below error:
Please assign party role Employee Responsible - Sales only once.
Type - Upsert (Complete Business Object)
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to Data Workbench work center
- Select Upsert tab
- Select Complete Business Object
- Upload the file
Cause
Using Data Workbench, mode 'Upsert' will create a new record in case the external key from file was not previously used to import data.
In that case you would add another 'Employee Responsible Sales' leading to observed error message.
Resolution
For that reason, you can use the following approach to update the Owner of the account:
Step 1: Export Header Entity Type 'Corporate Account', here you find an Field 'OwnerID' showing the current owner.
Step 2: Edit CSV and add your target OwnerID (->You overwrite the current owner)
Step 3: Perform Import: 'Individual Object', 'Update'
With that you don't have to rely on ExternalKeys that you might or might not have used before to import data and are deciding on either creation or update of Account Team data.
Keywords
Employee responsible sales, update employee responsible, remove employee responsible, account owner, account team , KBA , LOD-LE-BP-BP , Business Partner , Problem