When Deleting an Organization from a Hierarchy Error: ORA-20001: You cannot delete/update link in hierarchy used by Oracle Projects (Doc ID 1077543.1)

Last updated on JUNE 09, 2017

Applies to:

Oracle Project Foundation - Version 11.5.2 to 12.0.0 [Release 11.5 to 12.0]
Information in this document applies to any platform.
Checked for relevance on 4-Nov-2011


Goal

There is an interface for organization changes.  When trying to change a parent organization, the following error occurs with the DELETE_HIERARCHY_ELEMENT API.

ORA-20001: You cannot delete/update link in hierarchy used by Oracle Projects.

What does this error mean and why is it received on a parent change?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms