P6 Extended Schema Synonyms Do Not Display In BI Publisher Query Builder Using Microsoft SQL Server (Doc ID 1609782.1)

Last updated on MARCH 15, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.1 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Unable to access the P6 extended schema synonyms in BI Publisher Query Builder.

For example, the synonym P6PROJECT does not display, but the view PROJECT does display.

EXPECTED BEHAVIOR
-----------------------
User should be able to access the extended schema synonyms.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create reports using the synonyms in the Query Builder. The synonyms can still be used if manually writing the query.

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