Symptom
You have a requiremnet to modify the involved parties from an existing Opportunity. To achieve this you want to delete the existing assignment e.g. Sales Employee from an Opportunity.
When you use the Migration tool to delete the same you get below error:
Error: "Deletion not possible; specified data for OPPORTUNITY-ALL_PARTY with key PARTY_KEY-PARTY_ID-CONTENT = `xxxxxxxxx` AND RO does not exist".
Reproducing the Issue
You have downloaded the Migration template and deleted the Sales employee (or any required asignment) in the Involved Party sheet.
- Go to Business Configuration Work center
- Select the Overview view
- Search and select the Migration of Opportunities activity
- Select Migrate opportunities using the migration tool
- Set the Mode to Modify Existing Records
- In the migration tool select the CSV file you want to migrate
- Select Execute Migration Step by Step
Cause
It is not possible to delete the Sales Employee/current party assignment for an Opportunity using the Modify mode of Migration Tool for Opportunities.
Resolution
As a workaround you can use Data Workbench:
- Go to Data Workbench workcenter using HTML5 client
- Select Export view
- Select the object Opportunity Party Information
- Select Next and export and open the template
- Filter the required data which you want to delete
- In the filtered template add the column "ToBeDeleted"
- Enter the value for this column as "TRUE" and save the template
To import this updated template:
- Go to Update tab
- Select the object Opportunity Party Information
- Browse and Upload the updated template
- Select Next and let the task complete
Please refer to the:
2452236 - Unable to Edit an Existing Involved Party Within an Opportunity.
2312819 - Frequently Asked Question on Data Workbench Work Center
Keywords
KBA , LOD-CRM-EMP , Employee , How To