The CLEAN_PX_DELETE Procedure Deletes Some Valid Data From the ACTIVITYCODEHIERARCHY Table

(Doc ID 2349990.1)

Last updated on FEBRUARY 26, 2018

Applies to:

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

Symptoms

ACTUAL BEHAVIOR

Some valid data in the ACTIVITYCODEHIERARCHY table is missing after the DAMON/data_monitor background job is run.

EXPECTED BEHAVIOR

Valid project data should remain in the ACTIVITYCODEHIERARCHY table without being deleted by the data_monitor background job.

STEPS TO REPRODUCE

1. Run the Publish Enterprise Data job.
2. Check the number of records in the ACTIVITYCODEHIERARCHY table.
3. Manually run the CLEAN_PX_DELETE procedure.
4. Check the number of records in the ACTIVITYCODEHIERARCHY table; note that some valid data has been deleted.

Changes

 

Cause

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