What Are the WBSRSRC_ASSGN_XXX Views Visible in the P6 EPPM Database?
Last updated on MAY 24, 2017
Applies to:Primavera P6 Professional Project Management - Version 220.127.116.11 and later
Primavera P6 Enterprise Project Portfolio Management - Version 18.104.22.168 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 22.214.171.124 and later
Information in this document applies to any platform.
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?
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