My Oracle Support Banner

Tables for a P6 or UNIFIER Data Source Are Not Visible Inside the Query Builder During Report Creation in Analytics (Doc ID 2531737.1)

Last updated on OCTOBER 21, 2019

Applies to:

Primavera Analytics Cloud Service - Version 18.5 and later
Information in this document applies to any platform.



When working in the OBIEE query builder in Primavera Analytics, there are no available tables to select for creating the query.


Tables from the data source should be available for selection.


The issue can be reproduced at will using the following steps:

  1. Log on to Primavera Analytics Cloud.
  2. Select New > Data Model > Properties.
  3. Select New Data set and select data source P6RPT or UNIFIERSOURCE.
  4. Click Query Builder.
  5. Both the Catalog and Schema are blank, and there are no tables to select.




To view full details, 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 a vibrant support community of peers and Oracle experts.