SAP Knowledge Base Article - Preview

1853130 - Unable to use Date results in Web Intelligence Query Filter with values returned from another query


  • When refreshing a Web Intelligence query with Date object on Query Filter with values returned from another query you receive the error:
    • "Database error ORA-01830: date format picture ends before converting entire input string Error: (IES 10901) (WIS 10901)"
      • or
    • "Database error: ORA-01843: not a valid month . (IES 10901) (WIS 10901)"
  • This occurs only when the WebI report is based on UNX with Oracle as the data source



  • SAP Business Intelligence 4
  • SAP BusinessObjects Enterprise
  • Web Intelligence
  • Oracle


SAP BusinessObjects Business Intelligence platform 4.0


ORA-01843 not a valid month, ORA-01830 date format picture, web intelligence, webi, report filter, another query, BI4.0, BI4.x oracle error unx filter webintelligence refresh run wis10901 ies10901 error exception unable cannot will not execute type datetime object dimension idt ADAPT01692683 ADAPT1692683 ADAPT 01692683 1692683 TE: 5000493002 , KBA , BI-RA-WBI , Web Intelligence , Bug Filed

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.