My Oracle Support Banner

When Searching for Sites, an Error Occurs: "There Are XX Row(S) Missing In This Table Due To Insufficient User Privileges" (Doc ID 579230.1)

Last updated on NOVEMBER 12, 2019

Applies to:

Oracle Agile Product Collaboration - Version and later
Oracle Agile PLM Framework - Version and later
Information in this document applies to any platform.


User with all privileges (admin) gets "There are 10 rows missing due to insufficient privileges" when trying to search for Sites.

-- Steps To Reproduce:

1.Log in as Admin. Create site 'X' and site 'Y'
2.Search for all sites and keep this window open.
3.Remove site 'X'  from admin user's site preference.
4.Go to window in Step 1 and look at 'X' and disable the site.
It shows the warning message "No privilege" but it updates the database.
5.Now search for "X"
6.Error "There are 10 rows missing due to insufficient privileges" will now show.


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

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