My Oracle Support Banner

Deleted WBS Reappears When it Contains Logically Deleted Data (Doc ID 2518774.1)

Last updated on MARCH 22, 2022

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 18.8 and later
Information in this document applies to any platform.



Deleting a WBS which contains logically deleted data will result in the WBS (and non logically deleted data associated to it) to remove from display
without error but closing/reopening the project will result in the WBS and all non-logically deleted data to be present.

The following error is noted in the server log.

java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity
constraint (ADMUSER.FK_TASKACTV_TASK) violated - child record found


Logically deleted data under a WBS element should not result in "ORA-02292:
integrity constraint" exceptions preventing a WBS from actually being


The issue can be reproduced at will with the following steps:

  1. Log-in to P6 Professional
  2. Create a project
  3. Create a wbs elements
  4. Add one activity to one of the WBS elements
  5. Add one activity code to the activity
  6. Delete the activity (which will mark it logically deleted)
  7. Delete the WBS from the WBS view
  8. Note that the WBS appears to remove, but the record still exists in the PROJWBS table and will reappear when project is closed and reopened.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.