Baseline Information Is Not Publishing to WBSHIERARCHY Table (Doc ID 2267213.1)

Last updated on MAY 26, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.1.6.0 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 16.1.6.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
Baseline information is not publishing consistently to WBSHIERARCHY table for P6 reporting.

Note: Unless baselines are summarized separately from the project or updated recently, baseline information is not published to the WBSHIERARCHY table.

STEPS TO DUPLICATE:

  1. Create a new project
  2. Create 3 WBS elements and 3 activities underneath each WBS
  3. Create baseline form project created in step 1 and assign to new project
  4. Publish both the project and the baseline
  5. Review WBSHIERARCHY table and observe baseline information no populated
select *
from project p
join wbshierarchy wbs on
p.currentbaselineprojectobjectid=wbs.parentprojectid
where p.id='<Project ID>'

Cause

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