Primavera (MOSC)

MOSC Banner

UNable to see Primavera Synonyms via Oracle BI

edited Dec 30, 2013 6:55AM in Primavera (MOSC) 2 commentsAnswered
I am currently unable to view (either in existing data definitions or by building new ones) the P6 prefixed synonyms within Oracle BI Publisher.

We have a number of existing reports that currently will not execute because of this. If I try to edit the data model the SQL will not parse.
As a means of testing this I attempted to created a simple Data Model refrencing one of the Synonyms (e.e P6PROJECT) however this would not parse in SQL query view, nor was the synonym available for selection in QUery builder.

From within SQL Server I can see the View (PROJECT_U) upon which this synonym is based (as well as the underlying tables (PROJECT and PROJECTSECURITY which define the view). These can also be seen and referenced from within Oracle BI.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center