D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Positions cannot be deleted while dependent Position hierarchies exist. Delete dependent Position hierarchies and try again.

  • 1.  Positions cannot be deleted while dependent Position hierarchies exist. Delete dependent Position hierarchies and try again.

    GOLD CONTRIBUTOR
    Posted Aug 25, 2020 08:58 AM
    Hello!

    We are on AX 2012 R3 CU 13

    After gaining a better understanding of HR Job/Positions/Titles, we have been re-aligning workers in the HR module.  We have two positions that we cannot delete.  The following message is returned when we try to delete one of these positions:

              "Positions cannot be deleted while dependent Position hierarchies exist. Delete dependent Position hierarchies and try again."

    We have successfully deleted all other positions that were no longer needed.  We cannot find where any connection to anything exists.  There is nothing in Maintain Versions, no jobs, no titles, no employees, no history, no reports to and nothing reports to it.  The only thing that shows is when 'View In Hierarchy' is clicked, it shows linked to 'Organization'.

    Searching the internet and AXUG discussions, this does not show up.  A similar message concerning "unable to delete workers" is all that appears and the discussion there although similar, does not solve this matter.

    Guidance and suggestions are always welcome!

    #

    #AX2012
    #Functional
    #Intermediate
    #HR
    #Positions

    As always - thanks in advance!



    ​​​​​​​​

    ------------------------------
    Mark Yankovich
    Allegheny Bradford Corporation
    PA
    ------------------------------
    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 2.  RE: Positions cannot be deleted while dependent Position hierarchies exist. Delete dependent Position hierarchies and try again.

    GOLD CONTRIBUTOR
    Posted Aug 25, 2020 10:18 AM
    Hello,

    In the positions that won't delete, in the manage changes menu for those positions there should be a tab called Position hierarchies, can you see if there is something there. a lot of these records are date effective so even though nothing shows up currently there might be historical ties. Sorry  I don't have an ax 2012 screenshot to show you but should be the same as D365


    ------------------------------
    Juan Sebastian Grijalba
    Berkowitz Pollack Brant
    Miami
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 3.  RE: Positions cannot be deleted while dependent Position hierarchies exist. Delete dependent Position hierarchies and try again.

    GOLD CONTRIBUTOR
    Posted Aug 25, 2020 11:51 AM
    Juan,

    That was a quick response.  Thank you.

    There is not a 'Manage Changes' menu in AX 2012. This may be 'Maintain Versions' in AX 2012. The position in question is position '000203'. It is 'Inactive'. There is no information in any of the fast tab fields. Under 'Maintain Versions', each of the following tabs show 'This grid is empty' for this position:

                Position Details
                Position Worker Assignments
                Position Durations
                Position Hierarchies
                Budget Lines
                Labor Union

    When opening 'View In Hierarchy' from the Position screen, this is what is returned.



    ------------------------------
    Mark Yankovich
    Allegheny Bradford Corporation
    PA
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 4.  RE: Positions cannot be deleted while dependent Position hierarchies exist. Delete dependent Position hierarchies and try again.

    TOP CONTRIBUTOR
    Posted Aug 26, 2020 10:05 AM
    These relationships may show up as Party relationships. Thus, you may be able to view & edit them by going to the Party, scrolling down to the very bottom, and reviewing the relationships there.


    ------------------------------
    Tony Zeigler
    Senior Consultant
    Strategic Solutions NW
    Beaverton OR
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 5.  RE: Positions cannot be deleted while dependent Position hierarchies exist. Delete dependent Position hierarchies and try again.

    GOLD CONTRIBUTOR
    Posted 30 days ago
    Tony,

    Not finding it there.  But it may be more due to unfamiliar with how I would find the position.  All we have to go in is the Position ID of 000203.  Any tiips?


    ------------------------------
    Mark Yankovich
    Allegheny Bradford Corporation
    PA
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 6.  RE: Positions cannot be deleted while dependent Position hierarchies exist. Delete dependent Position hierarchies and try again.

    TOP CONTRIBUTOR
    Posted 30 days ago
    My assumption that it used the Address book relationships was incorrect.
    The position hierarchies have their own table, HcmPositionHierarchy. That table does have a set of valid-from valid-to fields. You may have to go into the table browser in the AOT to find the culprit. If you do - you'll want to test removing the entry in a dev environment before attempting in Prod...

    ------------------------------
    Tony Zeigler
    Senior Consultant
    Strategic Solutions NW
    Beaverton OR
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 7.  RE: Positions cannot be deleted while dependent Position hierarchies exist. Delete dependent Position hierarchies and try again.

    GOLD CONTRIBUTOR
    Posted 27 days ago
    Edited by Mark Yankovich 26 days ago
    Tony,

    That helped.  It was not found the the HcmPositionHierarchy (as it appears to reflect the current state hierarchy).  Looking at the other HcmPosition tables led us to HcmPositionDetail where we found position 000209 had reported to position 000203 and had 2 records - an older record with a valid start/expiration dates that reported to 000203, the other was the current state which reported to another position.  We then went back into the HR module in AX, opened position 000209, 'Maintain Versions' and clicked the 'Position Hierarchies' tab.  This displayed the older record and the current state record we saw when looking in the table.  Since we are cleaning up our structure, we 'Removed' the 'Position Hierarchies' record that reported to position 000203 and were then able to delete position 000203.

    Many thanks!

    ------------------------------
    Mark Yankovich
    Allegheny Bradford Corporation
    PA
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


If you've found this thread useful, dive deeper into User Group community content by role