My Oracle Support Banner

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

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
Goal
Solution


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