My Oracle Support Banner

Past Period Actuals (Stored Period Performance) Data Is Not Available In Data Warehouse / Analytics (Doc ID 2446305.1)

Last updated on SEPTEMBER 25, 2019

Applies to:

Primavera Analytics Cloud Service - Version 17.11.0.0 and later
Primavera Analytics - Version 17.11.0.0 and later
Primavera Data Warehouse - Version 17.11.0.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

In the P6 Extended Schema (by default, PXRPTUSER) Resource Assignment Actuals can be found in the P6RESOURCEASSIGNMENT / P6RESOURCEASSIGNMENTSPREAD views. The Actuals in these views are spread based on the assignment dates. However, if you are storing Actuals as Period Actuals, also known as stored period performance, these are stored in the P6RESASSIGNMENTPERIODACTUAL view in which it stores Actuals by Resource Assignment and Financial Period.  The data from P6RESASSIGNMENTPERIODACTUAL does not map into Data Warehouse preventing Analytics reporting on Period Actual data.


EXPECTED BEHAVIOR

Period Actual data (stored period performance from the P6RESASSIGNMENTPERIODACTUAL view) should map to the Data Warehouse for Analytics reporting. 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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