How To Rebuild The OBSPROJ Table In P6? (Doc ID 908570.1)

Last updated on NOVEMBER 04, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 6.0 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 16.1.0.0 to 16.1.0.0 [Release 16.1]
All Platforms

Goal

This document provides instruction for rebuilding the OBSPROJ table in Project Management. 

Note:

  • The OBSPROJ table is used to store security at the Project/EPS level and determines a users rights to access project data.  This information is then used to populate the uaccess table.  Invalid records in the OBSPROJ table can result in an attempt to add duplicate entries in the uaccess table resulting in login failure.
  • The OBSPROJ table is a working table and does not store any P6 data.  Therefore, it may be safely rebuilt without compromising P6 data.
  • It is suggested to complete the OBSPROJ rebuild while users are logged out of P6 Professional and ensure no users login while the rebuild is running.
  • If P6 Professional Users are unable to see projects after making changes to OBS (Responsible Manager) assignments, please see the following:  <Document 907647.1> - "P6 Projects are missing, OBSPROJ table not being updated as expected".

 

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