Sites Explorer "Unable to retrieve table from catalog {table name}. No access allowed for requested action."

(Doc ID 1904265.1)

Last updated on AUGUST 08, 2017

Applies to:

Oracle WebCenter Sites - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Symptoms

Unable to access table data in Sites Explorer


What is not working:
- Cannot view any tables in Sites Explorer that require access greater than Browser or Visitor acl access.
- Getting below popup error after login to Sites Exlporer.

"Unable to retrieve table from catalog {table name}.
No access allowed for requested action."

e.g.
"Unable to retrieve table from catalog CSProjects.
No access allowed for requested action."


The following error may be seen in the sites.log:


What is working:
- Can login to WebCenter Sites UI
- Can login to Sites Explorer
- Can view tables that only require a minimum of Browser or Visitor access

Cause

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