SAP Knowledge Base Article - Preview

2005481 - "ORA-01821: date format not recognized" when using toString() function on a Date object in a multisource universe on Oracle data Source.


  • When applying the toString() function to a Date type object in the SQL definition of the Dimension in a multisource universe on a Oracle DataSource, it gives an error when clicked on Show Values.
  • The error message seen is "ORA-01821: date format not recognized".



  • SAP BusinessObjects Business Intelligence 4.0
  • SAP Business Objects Business Intelligence 4.1


SAP BusinessObjects Business Intelligence platform 4.0


date format not recognized, IDT, Multisource, DFAT, ORA-01821, tostring(), toString(),toString Function, SAP BI 4.0, SAP BI 4.1, ADAPT01724599, ADAPT01724600  , KBA , BI-BIP-IDT , Information 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.