Unable to delete Entity error

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When attempting to delete an Entity from Administration > Finance > Entity, the following appears:

ERROR This entity cannot be deleted because it is assigned to an investment, department, or location

Cause

There are associated objects still active with the OBS.

Resolution

1. Run queries:

--a
select * from ENTITY
where id = 5xxxxxx

--b
select * from LOCATIONS
where entity_id = 5xxxxxx

--c
select * from DEPARTMENTS
where entity_id = 5xxxxxx

Note: 5xxxxxx is the ID of the Entity to remove.

 

2. Disassociate any Entity that needs to be deleted from 2 places:

For Locations, go to Administration > Finance > Setup > Locations
Remove associated departments.
Delete the location.

For Departments, Go to Home > Organization > Departments
Remove associated locations.
Delete the department.