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
Last updated on JULY 13, 2017
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 184.108.40.206 and later
Information in this document applies to any platform.
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:
javax.xml.ws.soap.SOAPFaultException: oracle.xdo.webservice.exception.OperationFailedException: PublicReportService::generateReport failed: due to oracle.xdo.servlet.data.DataException: Invalid parameters requested.
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