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 / 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))
 
 

Print Article