How To Rebuild The OBSPROJ Table In P6?
Last updated on FEBRUARY 07, 2018
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 6.0 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 126.96.36.199 to 188.8.131.52 [Release 16.1]
This document provides instruction for rebuilding the OBSPROJ table in Project Management.
- 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 P6 Web, 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".
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