Oracle Error Message
ORA-01862: the numeric value does not match the length of the format item
Reason for the Error
When the FX and FM format codes are specified for an input date, then the number of digits must be exactly the number specified by the format code. For example, 9 will not match the format specifier DD but 09 will.
Solution
Correct the input date or turn off the FX or FM format specifier in the format string.