My Oracle Support Banner

Business Intelligence Publisher Report Fails From BI Analytics Dashboard With Error 'oracle.xdo.XDOException: Invalid parameters requested.[[at' (Doc ID 2231399.1)

Last updated on APRIL 23, 2021

Applies to:

BI Publisher (formerly XML Publisher) - Version and later
Information in this document applies to any platform.


Business Intelligence Publisher Enterprise Edition , Administration and System Configuration issues

While running a BI Publisher Enterprise Edition (OBIEE) report the following error occurs:

[bi_server1] [ERROR] [] [oracle.xdo] [tid: 00] [userId: <anonymous>] [ecid: 6000-0000000000003fb6,0] [APP: bipublisher#11.1.1] Illegal parameter value: STAGE=All
[bi_server1] [WARNING] [] [oracle.xdo] [tid: 00] [userId: <anonymous>] [ecid: 6000-0000000000003fb6,0] [APP: bipublisher#11.1.1]

oracle.xdo.XDOException: Invalid parameters requested.[[at

Some additional observations:

1. the report runs find via the BI Publisher URL.
2. The report runs fine under Bi Analytics- Catalog
3. The report errors under the BI Analytics - Dashboard - with error message "invalid parameters requested"" with STAGE and P_SPEC parameters set to 'All' Values. If the parameters are set to a specific value in the table and parameter :SPECIES by P_SPEC is replaced within the data model query a 'no data found' error is received.


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.