Identify and resolve errors / BI Publisher

Body

Objective

  • I need to identify and resolve errors in BI Publisher 

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

User

  • BI Publisher Developer

System

  • 737842: Oracle Analytics Server (OAS)

 

Details

Details

Article ID: 117410
Created
Thu 10/1/20 12:56 PM
Modified
Tue 5/5/26 10:20 PM
Supported Office or Community
University Community of Students, Staff, and Faculty