My Oracle Support Banner

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 MAY 06, 2021

Applies to:

BI Publisher (formerly XML Publisher) - Version to [Release 11.1]
Information in this document applies to any platform.


BI Publisher, Report issues



BI Publisher report fails with the following error:

Illegal parameter value: PT_UNIEQ_KEY=xxxxxxxxxx
oracle.xdo.XDOException: 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)



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

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