SAP Knowledge Base Article - Preview

2198129 - BI4.1: In a WebI report and error is generated: "ORA-01843: not a valid month" when filtering on a Date with Oracle ODBC connection


  • When running a WebI report, with filter on date, ORA-01843: not a valid month error appears.
  • Issue is only reproducible with Oracle ODBC connection and works fine with Oracle Native Client connection.



  • SAP BusinessObjects Business Intelligence platform 4.1.
  • Web Intelligence
  • Oracle 11G R2



SAP BusinessObjects Business Intelligence platform 4.1


ODBC, Client, Oracle, ORA, 01843, Month, UDT, IDT, connection, webi, mismatch, month, altersession, connectinit, parameter,date, issue, timestamp, MON, MMM, YY, Native, webintelligence , KBA , BI-RA-WBI , Web Intelligence , 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.