The CLEAN_PX_DELETE Procedure Deletes Some Valid Data From the ACTIVITYCODEHIERARCHY Table
Last updated on FEBRUARY 26, 2018
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 18.104.22.168 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 22.214.171.124 and later
Information in this document applies to any platform.
Some valid data in the ACTIVITYCODEHIERARCHY table is missing after the DAMON/data_monitor background job is run.
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.
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