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

Last updated on OCTOBER 25, 2022

Applies to:

Symptoms

Description:
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.

Cause

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