My Oracle Support Banner

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

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.