The CLEAN_PX_DELETE Procedure Deletes Some Valid Data From the ACTIVITYCODEHIERARCHY Table
(Doc ID 2349990.1)
Last updated on SEPTEMBER 25, 2018
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 126.96.36.199 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 188.8.131.52 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!