My Oracle Support Banner

Error: "ORA-00942: Table Or View Does Not Exist" When Running P6 Report in BI Publisher (Doc ID 2757568.1)

Last updated on MARCH 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

The following error occurs in the P6 Web Access Logs when running report (example: to the /P6Reports/Administrative/Project Calendar Use.xdo), but the report does not display in P6.

Feb-25-2021 11:57:20 866, EST [ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR /rest/reports/initial/load?lazyLoad=false (User Id: 2755 DB Id: 3) com.primavera.rest.service.reports.helpers.JAXWSReportServiceWrapper12gr1LWF Building report: /P6Reports/Administrative/Project Calendar Use.xdo
MDC: {context=/rest/reports/initial/load?lazyLoad=false (User Id: 2755 DB Id: 3)}
Feb-25-2021 11:57:20 866, EST [ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR /rest/reports/initial/load?lazyLoad=false (User Id: 2755 DB Id: 3) com.primavera.rest.service.reports.helpers.JAXWSReportServiceWrapper12gr1LWF oracle.xdo.webservice.exception.OperationFailedException: PublicReportService::generateReportDefinition Failure: Due to getAvailableValues for Parameter [p_project_id], oracle.xdo.server.ServerException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: ORA-00942: table or view does not exist ; Data source: <DATA SOURCE>; Query: select /* dmtraceid=*/ /*+ MONITOR */ "P6PROJECT"."ID" as "ID" from "PXRPTUSER"."P6PROJECT" "P6PROJECT"
MDC: {context=/rest/reports/initial/load?lazyLoad=false (User Id: 2755 DB Id: 3)}
javax.xml.ws.soap.SOAPFaultException: oracle.xdo.webservice.exception.OperationFailedException: PublicReportService::generateReportDefinition Failure: Due to getAvailableValues for Parameter [p_project_id], oracle.xdo.server.ServerException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: ORA-00942: table or view does not exist

When running the report in BI Publisher, the following error occurs:

Parameter name: p_project_id oracle.xdo.servlet.data.DataException: ORA-00942: table or view does not exist ; Data source: <DATA SOURCE>; Query: select /* ...

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

  1. Attempt to run the report in P6 or BI Pubilsher
  2. Notice the list of values for the Project input parameter is blank and does not list any projects
  3. Run report and receive error Parameter name: p_project_id oracle.xdo.servlet.data.DataException: ORA-00942: table or view does not exist ; Data source: <DATA SOURCE>; Query: select /* ...

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


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