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

Last updated on AUGUST 08, 2023

Applies to:

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

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