Symptom
You tried to upload organizational units via Data Workbench work center. The task was successful. But the created org units are not set as sales, sales office, and reporting line units, even though you marked it as TRUE in the template. There is a message in the tab Organizational_Unit_Functions. Message: Record not created; parent foreign key not found.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to Data Workbench work center
- Click on Import view
- Click on Insert
- Click on Complete Business Object
- Search for Organizational Unit
- Click on Next
- Upload file
- Click on Next until Import
- Go to Monitor tab
- Select task name
- Note: 2 out of 2 records were successfully.
- Open file
- Go to Tab Organziational_Unit_Functions
Cause
A possible cause could be that the external keys used for OrganisationalUnitExternalKey in sub entities are not present in the Organisational_Unit tab.
Resolution
You need to make sure that the field External Key in Organizational_Unit tab matches with the field Organisational Unit External Key in the Organisational_Unit_Functions tab.
See Also
Organizational units, sales office, Data Workbench, no sales office checked, upload successful, org units not set as sales, sales office, reporting line units,
Keywords
KBA , LOD-CRM-INT-DWB , Data Workbench , LOD-LE-OM-OM , Org. Management , Problem