web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Answered

How to delete/obsolete/deactivate operations resources

(6) ShareShare
ReportReport
Posted on by 18
Dear all,
 
Did anyone come across a good solution to delete/obsolete/deactivate operations resources that are not required anymore? 
 
When trying to use the delete button, there is always something dependent (e.g. Production route) that prevents deletion.
 
Thanks
Florian
I have the same question (0)
  • Suggested answer
    Danny Bilodeau Profile Picture
    4,941 Super User 2026 Season 1 on at
    Hi Florian,
    I suspect that you already looked at Operations > Relations to pinpoint which routes may be linked to you obsolete resource? 
     
     
  • FH-24101032-0 Profile Picture
    18 on at
    Hi Danny,
     
    Thank you for your response!
     
    I did look at Operations>Relations and according to it, there are no routes linked to my obsolete resource.
     
    When trying to delete a certain resource, I'm getting following message:
    Resources cannot be deleted while dependent Production route exist. Delete dependent Production route and try again.
     
    When I open the production routes, all I can find are in works orders that are in status "Ended". I anyway tried to delete them through Excel AddIn, but that gave me following error message:
     
    Error Publishing Row

    Details:
    The deletion of a row in data set ProductionOrderRouteOperations was not published. Error message: 'Delete failed for table row of type 'ProdProductionOrderRouteOperationEntity'. Infolog: Info: Cannot delete a record in Resource requirement set (WrkCtrActivityRequirementSet).
    An update conflict occurred due to another user process deleting the record or changing one or more fields in the record..'
     
    That's where I'm currently stuck at, and I'm also not sure if I actually should delete the data in WrkCtrActivityRequirementSet or in the production routes.
     
    Would you know of any setup that would allow me to set a resource to obsolete or deactivated without deleting it?
     
    Thanks and BR
    Florian
  • Verified answer
    Danny Bilodeau Profile Picture
    4,941 Super User 2026 Season 1 on at
    Hi Florian,
    Completely overlooked that old routes copied to Production orders would interfere.  You would have to delete the old production orders that use an obsolete resource that you'd like to remove.  There are obviously some downside such as loss of history or traceability, so someone would need to weigh the importance of keeping there records against the need to remove obsolete resources. 
     
    If you have access to a copy of Production Environment, I suggest that you test this and assess just how far back you would need to go to be able to remove the obsolete resources.
     
    Go to Production Control>Periodic Tasks > Clean-Up >Production orders clean-up.  You see that there is no query beyond the <Ended before> date field to limit which production orders get deleted.
     
     
     
     
    Not sure of the reason to deactivate the resource, but alternatives to deleting production orders could be a combination of these:
    1) Change the description to highlight that they are Obsolete ("Obs-Coating", "Coating-No longer use", "ZZ-Coating")
    2) If its a Resources of Human resource type, terminate the Worker in HR module and delete the worker assignment from the resource.
    3) Depending on mechanism for resource assignment, remove anything that scheduling engine would use:
    - Remove Resource from any Resource groups
    - Remove any calendar assignment or assign to a Calendar that has not open days/hours
    - Change Efficiency percentage to 0
    - Remove any Capabilities (in FastTab) taht could be use to assign job 
     
    There might be other ideas out there...
     
     
  • FH-24101032-0 Profile Picture
    18 on at
    Hi Danny,
     
    Thank you for your detailed suggestions!
     
    I was hoping for a toggle or something similar that would prevent a resource from being used but it sounds like something like that is not available. We are inconsistently using your suggestion 1) Change the description to highlight that they are Obsolete ("Obs-Coating", "Coating-No longer use", "ZZ-Coating")
    so I will propose to my teams to standardize this approach so it can be used in filters etc.
     
    BR
    Florian
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 149 Super User 2026 Season 1

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 102 Super User 2026 Season 1

#3
Laurens vd Tang Profile Picture

Laurens vd Tang 97 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans