Dynamics Community Forum Thread Details

Cannot delete records from HcmPositionHierarchy table - Delete button disabled in Table Browser

I'm trying to delete positions in Dynamics 365 Finance and Operations, but I get this error:
"Cannot delete Positions while dependent Position hierarchies exist. Delete dependent Position hierarchies and try again."

I navigated to the HcmPositionHierarchy table using Table Browser (&mi=SysTableBrowser&TableName=HcmPositionHierarchy), and I can see all the records that need to be deleted. However, the "Delete" button (Eliminar) is grayed out/disabled.

What I've tried:

I have full administrator/super user permissions

Uploading a blank template doesn't delete the records (it just gets ignored)

I cannot find a "Delete" mode option in Data Management when importing

I don't have direct SQL access to the database

Question:
How can I delete records from HcmPositionHierarchy when the delete button is disabled in Table Browser? Is there a system setting, maintenance mode, or data management configuration that allows bulk deletion of these records?

Categories:

Dynamics 365 Human Resources

Dynamics 365 Finance

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL