SAP Knowledge Base Article - Preview

3561240 - "The following database error occured: ORA-01719: Outer join operator (+) not allowed in operand of OR or IN." Error in Web Intelligence

Symptom

  • When refreshing a Web Intelligence report, the following error is encountered: "The following database error occured: ORA-01719: Outer join operator (+) not allowed in operand of OR or IN. For more information please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901)".
  • The SQL query includes an outer join inside an IN an OR clause fails to execute properly.
  • Issue can be reproduced with both Universe based Web Intelligence Report or a report based on Free Hand SQL using Oracle as reporting database.


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.x
  • Oracle

Product

SAP BusinessObjects Business Intelligence platform 4.3

Keywords

ORA-01719, Web Intelligence reports, Oracle, outer joins , KBA , BI-RA-WBI , Web Intelligence , BI-BIP-SL , Semantic Layer , BI-BIP-UDT , Universe Design Tool , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.