My Oracle Support Banner

'Error: Milestone Activities with Units (XXXX occurrences)' When Running the P6 Project Integrity Checker (Doc ID 3009781.1)

Last updated on JUNE 21, 2024

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 22.12.11.0 to 23.12.4.0 [Release 22.12 to 23.12]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 24.1 to 24.4 [Release 24.1 to 24.4]
Information in this document applies to any platform.

Symptoms

When executing the Project Checker, the following error occurs:

Error: Milestone activities with units ( XXXX occurrences)
Integrity Check ID:  check 68

select task.proj_id ProjectId,project.proj_short_name ProjectIdName,task.task_id ActivityId,task.task_code ActivityCode,CASE WHEN project.orig_proj_id IS NULL THEN 'N' ELSE 'Y' END IsBaseline from task,project where (task.proj_id IN (<project ID>) OR project.orig_proj_id IN (<project ID>)) AND task_type in ('TT_Mile','TT_FinMile') and ( target_work_qty != 0 or target_equip_qty != 0 or (select sum(target_qty) from taskrsrc where rsrc_type= 'RT_Mat' and taskrsrc.task_id = TASK.task_id) != 0 or act_work_qty != 0 or act_equip_qty != 0 or (select sum(act_reg_qty) from taskrsrc where rsrc_type= 'RT_Mat' and taskrsrc.task_id = TASK.task_id) != 0 or remain_work_qty != 0 or remain_equip_qty != 0 or (select sum(target_qty) from taskrsrc where rsrc_type= 'RT_Mat' and taskrsrc.task_id = TASK.task_id) != 0 or est_wt != 0) AND TASK.proj_id = PROJECT.proj_id

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!

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