My Oracle Support Banner

Running Report in BI Publisher on P6PROJECT Synonym Returns No Output Even Though There is Data in P6PROJECT (Doc ID 2757558.1)

Last updated on MAY 17, 2021

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
-----------------------

When running a report in BI Publisher that contains a query on P6PROJECT (or any synonym that invokes project-level security), there is no output (0 rows are returned for the query).

When executing the same query on the PROJECT Extended Schema (PX) View instead of the P6PROJECT Synonym, there are projects returned.

EXPECTED BEHAVIOR
-----------------------

The report should return output for the projects contained in P6PROJECT. Querying on P6PROJECT should return results because P6PROJECT contains project data.

STEPS
-----------------------

  1. Login to BI Publisher
  2. Select any Report that has a Data Set or List of Values that queries P6PROJECT in its Data Model
  3. Run report and notice there is no output (and the p_project_id parameter did not list any projects to select at run time for those reports requiring this input parameter)

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.