Material Resource Units Imported From An Excel (XLS) Spreadsheet Are Multiplied By The Hours Per Day (Doc ID 902299.1)

Last updated on JULY 05, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 5.0 to 7.0 [Release 5.0 to 7.0]
Primavera P6 Professional Project Management - Version 5.0 to 7.0 [Release 5.0 to 7.0]
Primavera Contractor - Version 5.0 and later
All Platforms
***Checked for relevance on 28-Nov-2012***

Symptoms

Material Resources imported from an XLS file are multiplied by the hours/day setting in Admin Preferences, Time Periods When importing Resource Assignments using the Excel Import/Export, Budgeted Units for Material Resources are multiplied by the hours/day setting defined under Admin, Admin Preferences, Time Periods.

For example, if the Units Format, Unit of Time is set to Day, the material resource units are multiplied by the number of hours defined per day. In the example below, the units would be multiplied by 8.

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