My Oracle Support Banner

OBIEE 12c :: Invalid YEAR value like '0000' with in datatype TIMESTAMP results database error - ORA-01841: (full) year must be between -4713 and +9999, and not be 0 (Doc ID 2644346.1)

Last updated on MARCH 02, 2020

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Unlike OBIEE 11g, in OBIEE 12c the report that uses Invalid YEAR value like '0000' with in datatype TIMESTAMP results database error "ORA-01841: (full) year must be between -4713 and +9999" -

For e.g. -

TIMESTAMP OBIEE datatype in column formula TimestampAdd(SQL_TSI_YEAR,year("- Pkg Rpt Exception Calendar"."Pkg Rpt Exc Day Date") ,timestamp '0000-01-01 00:00:00') produces following error message in OBIEE 12c -

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.