My Oracle Support Banner

Activity Relationships Exported to XLS Displays in Hours Irrespective of User Preferences (Doc ID 2904615.1)

Last updated on OCTOBER 25, 2022

Applies to:

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


While exporting any project to XLS format which includes "Activity Relationships", 2 of the attribute fields i.e. "Predecessor Remaining Duration" and "Successor Remaining Duration" always export in Hours even if the Duration format is set as Days in User Preferences.
"Lag" works as per the User Preferences settings.
Also the Excel output headers for affected attributes shows (d), and values are actually in hours, so this could be confusing.

Steps To Reproduce:

  1. In a project add 2 activities and create any relationship between them with a lag.
  2. Verify that duration format is set to Days in Edit->User Preferences.
  3. Export to Excel, modify template to add "Lag" "Predecessor Remaining Duration" "Successor Remaining Duration" columns in Activity Relationship category.
  4. The Excel output would contain "Predecessor Remaining Duration" and "Successor Remaining Duration" in hours, header having (d) symbol.
  5. Lag honors the User Preference setting and displays in Days or Hours.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.