SAP Knowledge Base Article - Public

2490172 - Unbale to Delete Involved Parties for Opportunity Using Migration Tool

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:

  1. Go to Data Workbench workcenter using HTML5 client
  2. Select Export view
  3. Select the object Opportunity Party Information
  4. Select Next and export and open the template
  5. Filter the required data which you want to delete
  6. In the filtered template add the column "ToBeDeleted"
  7. Enter the value for this column as "TRUE" and save the template

To import this updated template:

  1. Go to Update tab
  2. Select the object Opportunity Party Information
  3. Browse and Upload the updated template
  4. 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

Product

SAP BUSINESS BYDESIGN 1708 ; SAP Hybris Cloud for Customer add-ins 1705