Fusion - BI Publisher - Error - ORA-00920: Invalid Relational Operator - When Multiple Selection Values Selected In Parmater In Data Model - "NULL Value Passed" (Doc ID 2020360.1)

Last updated on JUNE 21, 2023

Applies to:

Symptoms

On : 11.1.9.2.0 version, Technology Management - Reports/Analytics

When attempting to view data for multiple parameters,
the following error occurs.

ERROR
-----------------------
oracle.xdo.XDOException:java.sql.SQLSyntaxErrorException: ORA-00920: invalid ralational operator

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a new Data Model

SELECT PARTY_ID FROM HZ_PARTIES WHERE (PARTY_ID IN NVL(:PARMPARTY_ID, party_id))

2. Create List Of Values
3. Create Parameters using the Option > "Multiple Selection" > "Can Select All" > "Null Value Passed"
4.Save Data Model
5. Select Multiple Parameter Values
6. Click On View to see the below Error

oracle.xdo.XDOException:java.sql.SQLSyntaxErrorException: ORA-00920: invalid ralational operator

oracle.xdo.servlet.data.DateException:
oracle.xdo.XDOException
java.sql.SQLSytaxErrorException: ORA-00911: invalid character

Due to this issue, users cannot multi-select the parameters.

Changes

Cause

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