IDM: "not a valid month" error

Hi,

I have a problem with an IDM job...

The SQL Query produces the error:
ORA-01843: not a valid month
01843. 00000 -  "not a valid month"
*Cause:    
*Action:

The part of the statement producing the error is

select TO_DATE('08-12-2011', 'DD-MM-YYYY'), to_date(avalue||'','YYYYMMDD') 
from mxiv_sentries 
where attrname = 'RS_ABSENT_TO' 
AND NOT (AVALUE = '00000000' OR AVALUE = 'undefinedundefined')
and TO_DATE(avalue||'','YYYYMMDD') >= TO_DATE('08-12-2011', 'DD-MM-YYYY')

If I execute only the first part

select TO_DATE('08-12-2011', 'DD-MM-YYYY'), to_date(avalue||'','YYYYMMDD') 
from mxiv_sentries 
where attrname = 'RS_ABSENT_TO' 
AND NOT (AVALUE = '00000000' OR AVALUE = 'undefinedundefined')

the system produces no error

Next strange thing is that on our DEV system the query runs without error, only on production the error occurs.

Edited by: Habib Pleines on Dec 8, 2011 3:53 PM