Tag Archives: ORA-01843

SQL worked fine on pre 12c but failed with “ORA-01843: not a valid month” after upgrade.

Recently on OTN, OP posted below scenario. When he ran below SQL, it failed with “ORA-01843” in oracle 12c version. select FISCAL_SYSTEM_PERIOD_CAL_YR_EQ, calendrical_equivalent from fiscal_system_periods where calendrical_equivalent > 0 and to_date(FISCAL_SYSTEM_PERIOD_CAL_YR_EQ || ‘, ‘ || 2014,’Month, YYYY’) >= to_date(‘November, 2014’,’Month, … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , | Leave a comment