How to look default EPS or Activity view assigned to user using SQL Query – Primavera P6/Oracle

Some times, Primavera P6  users does not see the EPS or Activity page . The reason is not because of the browser or java applets. The EPS/Activity View or filters in the view has got corrupted. The view they see at first time after they logged in is called Default view.  To set a default view, the user needs to navigate to the Manage view, click on the gear icon on the left side of the view which appears on mouse over and set Active.

When a user does not able to see his view, we need to investigate what default view the user is currently  Assigned in the database. Further, we can check what columns filters and group by are assigned to the view. We can look this option to troubleshoot further. 

The purpose of this post is to find the default view assigned to the user so we can dive to that. 

Assume, the P6 EPPM is installed on Oracle database 

Find the Default EPS/Activity User using Oracle SQL query 

1. Log into ADMUSER schema and run the following SQL query . Replace the USER_NAME with your P6 user name (Login name). This will return blob data.  The BLOB data is an XML file, Look for the following parameter ProjectLWFViewId. 

Select user_data from USERDATA where user_id = (select user_id from users where user_name = ‘’) and topic_name = ‘pweb_settings’;

Note: If you are using SQL Developer, click on the pencil icon near the blob value, Click on the Text check box and click on the Saved Text tab to see the XML . Copy and paste the xml in notepad to look for ProjectLWFViewId

2. Remove the first four character of the value, decode the remaining character using base64 and pass the decoded value in the following Sql Query to find the default value. That’s it. 

select * from viewpref where view_pref_id = ‘’

Note: Search  for base64 in google. You will get plenty of option to decode the value.