Primavera (MOSC)

MOSC Banner

Issue with At Completion Cost from assignment spread

edited Jun 25, 2018 8:30AM in Primavera (MOSC) 2 commentsAnswered ✓

When creating a report in BI Publisher containing values from the assignment spread I have an issue with the At Completion Cost field.

In my report At Completion Cost only equal Actual Cost + Remaining Cost when the assignment have a role or a resource. When the assignment have both a role and a resource At Completion Cost is empty. There is no issue with At Completion Units.

Any idea what could be causing this?

Version: P6 17.12.4.0

Query:

select

     sum(RAS.ACTUALUNITS),

     sum(RAS.ACTUALCOST),

     sum(RAS.REMAININGUNITS),

     sum(RAS.REMAININGCOST),

     sum(RAS.ATCOMPLETIONUNITS),

     sum(RAS.ATCOMPLETIONCOST)

from PXRPTUSER.RESOURCEASSIGNMENTSPREAD RAS

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center