Error: "Invalid Input Parameter" When Selecting An Input Parameter For A Report In P6, Where The Report Parameter Does Not Map To The Intended Database Column (Doc ID 1537740.1)

Last updated on JULY 13, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.1.1.0 and later
Information in this document applies to any platform.

Symptoms

Using a BI Publisher Report that is configured to use an input parameter (for example, p_eps_id) where the input parameter 'list of value' SQL Query is set to select on a column that it was not designed to map to (for example, P6EPS.objectID), when running the report from within P6 and selecting the populated list based on the design of the parameter (for example EPS list if using the p_eps_id), the EPS Name gets returned in the field and when the report runs it fails with the following error because it does not match the column defined in the report's data model SQL Query:

Error
-----------------------
javax.xml.ws.soap.SOAPFaultException: oracle.xdo.webservice.exception.OperationFailedException: PublicReportService::generateReport failed: due to oracle.xdo.servlet.data.DataException: Invalid parameters requested.

Cause

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 hundreds of Community platforms