What Are the WBSRSRC_ASSGN_XXX Views Visible in the P6 EPPM Database? (Doc ID 2266836.1)

Last updated on MAY 24, 2017

Applies to:

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

Goal

There are a set of Views in the database that appear to provide summary Resource and Role data by WBS and Project by time period:

dbo.WBSRSRC_ASSGN_BY_(proj, projrole, role, rsrcc)_BY_(week, month, quarter, year)
dbo.WBSRSRC_ASSGN_SUMMARY_BY_(week, month, quarter, year)
dbo.WBSRSRC_ASSN_BY_(proj, projrole, projrsrc, summary)_BY_FP

The views don't appear to be available to P6 users.  How can they be utilized?


Solution

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