EPS_WID = Null in Fact Spread Tables After ODI ETL Execution Causing Subject Areas Within Analytics From Displaying EPS / Project Hierarchy Data

(Doc ID 2323786.1)

Last updated on JANUARY 02, 2018

Applies to:

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


Using Data Warehouse configured with ODI ETL:

When running the ODI Daily ETL, the EPS_WID will be null in tables W_ACTIVITY_SPREAD_F, W_PROJECT_SPREAD_F and W_RESOURCE_ASSIGNMENT_SPREAD_F for a published project regardless of when the "Publish Enterprise Summaries" global scheduled service is executed.
Additionally, the LOAD_PLAN_INITIAL_LOAD load plan execution does not populate the EPS_WID in tables W_ACTIVITY_SPREAD_F, W_PROJECT_SPREAD_F and W_RESOURCE_ASSIGNMENT_SPREAD_F for new projects inserted into STAR or for existing projects updated by the execution.

When running the Daily ETL / Full ETL via ODI, for the EPS_WID to be properly updated in tables W_ACTIVITY_SPREAD_F, W_PROJECT_SPREAD_F and W_RESOURCE_ASSIGNMENT_SPREAD_F.

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

  1. Create new EPS
  2. Create new Project under new or existing EPS
  3. Add WBS / Activities / Resource Assignments to new project
  4. Publish Project
  5. Run 'Publish Security' global scheduled service
  6. [If the EPS was newly created] Run 'Publish Enterprise Summaries' global scheduled service (which will make the new EPS available in the extended schema EPS view)
  7. Run Daily ETL  (from web based config utility)


The issue has the following business impact:
This prevents usage of the 'Activity' Subject Area within Analytics from properly building an analysis to display the EPS / Project Hierarchy.




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 hundreds of Community platforms