My Oracle Support Banner

Not Able To See Historical Data In Primavera Analytics (Doc ID 2319172.1)

Last updated on MARCH 21, 2019

Applies to:

Primavera Analytics - Version and later
Information in this document applies to any platform.


On Primavera Analytics, after deleting a resource from an activity in P6 EPPM, and after assigning a new resource in P6 EPPM, the result is that the deleted resource name and time-sheet hours do not appear in the Analytics report.

The expected behavior is to see all the historical data in the report for your Resource Assignment.


  1. Deleted resource from the activity and assigned new resource.
  2. Submitted hours in timesheet against the activity.
  3. Approved the resource timesheet hours in P6.
  4. Ran apply actuals to update the actuals hours on the resource assignment.
  5. Published Global Schedule Services.
  6. Published the project.


  1. Run STARETL to move the data into STAR schema.
  2. Attempt to view a report in OBIEE.
  3. Created a new analysis using 'Primavera - Resource Assignment History' Subject Area.
  4. Select Result tab.
  5. Notice that no deleted resource name and timesheet hours appears in the report.



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.