Data in P6 Spread Table Does Not Match P6 Actual Data (Doc ID 1996177.1)

Last updated on APRIL 13, 2015

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.1 2.0 and later
Information in this document applies to any platform.

Symptoms

This information is applicable to all P6 EPPM 8.1 and later versions.

 

Example of symptom:


select to_char(enddate, 'YYYY.MM') as perioddate, sum(NVL(plannedcost, '0')) as planned_cost
from p6resourceassignmentspread
where projectobjectid = 1150
group by to_char(enddate, 'YYYY.MM')
order by perioddate;

Results:
2014.01 232642.1325
2014.02 63791.23478
2014.03 61427.46378
2014.04 47609.59929
2014.05 54519.85597
2014.06 36386.74265
2014.07 39720.58315
2014.08 50303.58133
2014.09 42831.88903
2014.10 47216.90933
2014.11 36556.14763
2014.12 47658.79113
2015.01 41812.62614
2015.02 28902.22464
2015.03 71144.14564
2015.04 86358.19313
2015.05 62304.37584
2015.06 58536.17664
2015.07 36644.36853
2015.08 6588.575554



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