If you experience this error when trying to delete a location, it is most likely because it is set as the location on an existing career history record.
To locate the career history records where the location is assigned, follow these steps.
In the Admin Tool, click Import/Export Data.
Click Create an export definition.
Click Select the data to export.
Change the database to SelectHR.
Log in.
Copy the below SQL:
SELECT Person_Snapshot.[Person_NUMBER], Person_Snapshot.[EFFECTIVE_STATUS], Person_Snapshot.[FIRST_NAME], Person_Snapshot.[SURNAME], Employee.[CAREER_HISTORY].[LOCATION_NUMBER], ORGANISATION_LOCATIONS.[LOCATION_NAME]
FROM Person_Snapshot
INNER JOIN Employee.[CAREER_HISTORY].[APPOINTMENT_NUMBER] = Employee.[CAREER_HISTORY].[APPOINTMENT_NUMBER]
INNER JOIN ORGANISATION_LOCATIONS ON ORGANISATION_LOCATIONS.[LOCATION_NUMBER] = Employee.[CAREER_HISTORY].[LOCATION_NUMBER]
WHERE ORGANISATION_LOCATIONS.[LOCATION_NAME] = 'replace_me'In the top left of the data export window, click Options, Paste SQL from clipboard.
Enter the location name in the criteria field where it says replace me.
Click Data.
Once you have identified the records with the specific location, find the record on the website in the Career History process, then remove it from the record.