BI Publisher / Error Record

Objective

  • To identify errors in BI Publisher and provide corresponding causes and resolutions

User

  • BI Publisher Developer

Environment

  • 737842: Oracle Analytics Server (OAS)

Error + Resolution

Error Message
  ORA-00920: invalid relational operator:
Affected User / Client Office / Action Selecting multiple options on prompt
Cause Code needs to be updated in Data Model
Applied Resolution / Workaround Select only single option and contact owner of the data model
Associated Procedure

Correction for the issue in data model:

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

Replace the NVL with COALESCE and use the below SQL Statement:

  SELECT PARTY_ID FROM HZ_PARTIES WHERE (COALESCE(null, :PARMPARTY_ID) is null) OR (party_id IN (:PARMPARTY_ID))
 
 

Details

Article ID: 117410
Created
Thu 10/1/20 12:56 PM
Modified
Mon 11/6/23 11:33 AM
Can you resolve this issue yourself?
Yes! This is self-service with a smile.
Supported Office or Community
University Community of Students, Staff, and Faculty