How to bulk set RITMs inactive (active=false) for particular Assignment Group

storiesbyjo
Tera Contributor

Hi All,
I need to make RITMs inactive (active = false) where the assignment group is "Test Group"`. There are approximately 30,000+ matching records.

Questions:

  1. What is the best practice to perform this bulk update safely in Production?
  2. Should I use Scripts – Background?
  3. Any rollback considerations or audit tips you suggest?
1 REPLY 1

jonsan09
Giga Sage

I would use a background script. Testing in a subProd instance first. I'd suggest utilizing ".setLimit()" to run in batches to catch any issues and prevent instance performance degradation. You might also want to log the RITM number before setting to inactive.

 

A few other things to consider:

  • Does the RITM have any open or active tasks or approvals?
  • Do you need to avoid modifying timestamps and running engines (i.e notifications, business rules, flows)
    • You may need to utilize "setWorkflow()" and/or "autoSysFields()"
  • Depending on your use case and if other related records need to be closed (catalog tasks, approvals), you might be better off cancelling at REQ level. (Might now work if used with "setWorkflow()" )