My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

ACTUAL BEHAVIOR

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


EXPECTED BEHAVIOR

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

STEPS

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.

Cause

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
Symptoms
Cause
Solution
References


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