BIP 11G - Running Report Fails With Error "Invalid Parameters Requested" When Parameter LOV Is Using Some SQL Functions (to_char, sysdate, upper, etc)
(Doc ID 2096896.1)
Last updated on SEPTEMBER 05, 2024
Applies to:
BI Publisher (formerly XML Publisher) - Version 11.1.1.7.x to 11.1.1.9.0 [Release 11.1]Information in this document applies to any platform.
Goal
BI Publisher 11.1.1.7, Report issues
BI Publisher report fails with the following error:
Illegal parameter value: PT_UNIEQ_KEY=xxxxxxxxxx
oracle.xdo.XDOException: oracle.xdo.servlet.data.DataException: Invalid parameters requested
The report parameters are provided below:
1. Parameter PT_UNIEQ_KEY refer to List of Values:unieq_key
2. List of Values:
unieq_key (type:SQL Query) SELECT 'UNIEQ_KEY',to_char(sysdate,'YYYYMMDDHH24MISS') from dual
3. Set the global variable in event trigger package(PL/SQL)
Solution
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
| Goal |
| Solution |
| References |