My Oracle Support Banner

W_ACTIVITY_SPREAD_F Fact Table Contains Null Value For RESOURCE_WID And RESOURCE_OBJECT_ID Columns When It Should Contain The Primary Key Value For The P6 EPPM Primary Resource Of Activity (Doc ID 2376766.1)

Last updated on APRIL 19, 2018

Applies to:

Primavera Data Warehouse - Version 17.11.0.0 to 17.12.0.0 [Release 17.11 to 17.12]
Primavera Analytics - Version 17.11.0.0 to 17.12.0.0 [Release 17.11 to 17.12]
Primavera Analytics Cloud Service - Version 17.11.0.0 to 17.12.0.0 [Release 17.11 to 17.12]
Information in this document applies to any platform.

Symptoms

 ACTUAL BEHAVIOR
------------------------
When an activity contains a primary resource, execution of either the LOAD_PLAN_INITIAL_LOAD or LOAD_PLAN_DAILY is setting a null value for the following columns in the W_ACTIVITY_SPREAD_F table:

As a result of this issue, analysis creation from "Primavera - Activity" subject area which join W_RESOURCE_D/W_ACTIVITY_SPREAD_F (adding columns from the resource and activity fact grouping) will return no results.

 

EXPECTED BEHAVIOR
------------------------
The W_ACTIVITY_SPREAD_F.resource_wid & W_ACTIVITY_SPREAD_F.resource_object_id columns should be populated with associated values for the primary resource assigned to the activity.

 

STEPS TO REPRODUCE:
------------------------

  1. Within P6 EPPM:
    1. Create a project
    2. Add an activity and set a primary resource on the activity
    3. Publish the project
  2. Execute either LOAD_PLAN_INITIAL_LOAD or LOAD_PLAN_DAILY
  3. For rows added to W_ACTIVITY_SPREAD_F, note the null value for:
    • resource_wid
    • resource_object_id

 

ADDITIONAL INFORMATION
-----------------------------
The sample dashboard "project health, activity worksheet" page will return no results because of this issue.

The SQL which is formed from the analysis on the dashboard is:

WITH
SAWITH0 AS (select sum(T133.PLANNED_LABOR_UNITS) as c1,
T86.FINISH_DATE as c2,
T86.START_DATE as c3,
T86.FINISH_DATE_VARIANCE as c4,
T86.ACTIVITY_NAME as c5,
T86.PRIMARY_RESOURCE_NAME as c6,
T79.RESOURCE_NAME as c7,
concat(concat(concat(concat(concat(concat('<a target="_blank" href="',
'http://localhost:8080/p6'),
'/bookmark?uri=navigatetopage&ctx=projectList='), cast(T94.WBS_OBJECT_ID as
VARCHAR ( 10 ) )), '&key=activities">'), 'Project Activities'), '</a>')
as c8,
T105.PROJ_LEVEL_NAME as c9,
case when T86.TOTAL_FLOAT is null then 0.0 else T86.TOTAL_FLOAT end as
c10,
case when T86.ACTIVITY_STATUS = 'TK_Active' then 'In Progress' when
T86.ACTIVITY_STATUS = 'TK_Complete' then 'Completed' else 'Not Started' end
as c11
from
W_RESOURCE_D T79 /* Dim_W_RESOURCE_D_Resource */ ,
W_WBS_HIERARCHY_D T105 /* Dim_W_WBS_HIERARCHY_D_WbsHier */ ,
W_PROJECT_D T94 /* Dim_W_PROJECT_D_Project */ ,
W_ACTIVITY_D T86 /* Dim_W_ACTIVITY_D_Activity */ ,
W_ACTIVITY_SPREAD_F T133 /* Fact_W_ACTIVITY_SPREAD_F_Activity_Spread */
where ( T79.ROW_WID = T133.RESOURCE_WID and T86.ROW_WID = T133.ACTIVITY_WID
and T94.ROW_WID = T133.PROJECT_WID and T86.ACTIVITY_STATUS = 'Not Started'
and T94.PROJECT_NAME = 'Analytics' and T105.ROW_WID = T133.WBS_WID )
group by T79.RESOURCE_NAME, T86.ACTIVITY_NAME, T86.FINISH_DATE,
T86.START_DATE, T86.FINISH_DATE_VARIANCE, T86.PRIMARY_RESOURCE_NAME,
T105.PROJ_LEVEL_NAME, case when T86.TOTAL_FLOAT is null then 0.0 else
T86.TOTAL_FLOAT end , case when T86.ACTIVITY_STATUS = 'TK_Active' then 'In
Progress' when T86.ACTIVITY_STATUS = 'TK_Complete' then 'Completed' else 'Not
Started' end , concat(concat(concat(concat(concat(concat('<a target="_blank"
href="', 'http://localhost:8080/p6'),
'/bookmark?uri=navigatetopage&ctx=projectList='), cast(T94.WBS_OBJECT_ID as
VARCHAR ( 10 ) )), '&key=activities">'), 'Project Activities'), '</a>'))
select 0 as c1,
D1.c2 as c2,
D1.c3 as c3,
D1.c4 as c4,
D1.c5 as c5,
D1.c6 as c6,
D1.c7 as c7,
D1.c8 as c8,
D1.c9 as c9,
D1.c10 as c10,
D1.c11 as c11,
0 as c12,
0 as c13,
D1.c1 as c14
from
SAWITH0 D1
order by c9

Changes

 

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.