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 JULY 16, 2018

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.


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