BI Publisher / Error Record

Body

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 / Action User selecting multiple options on prompt
Cause Code needs to be updated in Data Model
Applied Resolution 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

Details

Article ID: 117410
Created
Thu 10/1/20 12:56 PM
Modified
Wed 11/13/24 11:51 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