Unable to Access Options in Dropdowns for Catalog or Schema in BIP When Using Query Analyzer in Internet Explorer (Doc ID 2120679.1)

Last updated on APRIL 19, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.2.0.0 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 8.2.4.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Catalog and Schema options are greyed out for users in the query analyzer, regardless of permissions or module access granted in the product.

EXPECTED BEHAVIOR
-----------------------
All buttons and options available in Business Intelligence Publisher (BIP) for the user.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in to BIP
2. Open Data Model, Data Sets.
3. In the action drop down, select SQL Query, Query Builder
5. See greyed out Catalog and Schema in the top left corner of the screen.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot change the catalog or schema in BIP query builder.

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