My Oracle Support Banner

Exporting a Large Volume of Data from Resource Assignments to Excel Takes a Long Time (Doc ID 2712987.1)

Last updated on OCTOBER 05, 2020

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 19.12.3.0 to 19.12.8.0 [Release 19.12]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

Exporting a large volume of data in P6 Web from Resource Assignments to Microsoft Excel format takes a long time to complete.

The view contains the following configuration:
Columns: 4 Project Codes, 3 Global Activity Codes, and 7 Resources Codes.
Filtering: Set to filter on a Project Code and Demand, Cost and Supply projects.
Grouping: 4 groupings (Project, 2 Project Codes and 1 Resource Code).
Sorting: Activity Name Ascending.
Gantt: Sight Lines and Non-Work time ticked; Timescale = Financial Period.
Spreadsheet: Timescale = Financial Period; Columns = Planned Costs, Planned Units, Period Actual Cost, Period Actual Units; Start and Finish Dates for spreadsheet span 12months.

EXPECTED BEHAVIOR

Performance should be better while exporting large volume of data to excel from Resource Assignments.

 

The issue can be reproduced at will with the following steps:

  1. Log into P6 Web.
  2. Go to the Resource Assignments view.
  3. Create a view and filter as per above.
  4. Click Export.
  5. Monitor the View Service Status list, or wait for notification.

Changes

 

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.