Parallel job reports failure (code 13)- Date conversion

[techiexavier]

Hi All,

job: OLTP->Transformer->Flat file

We are facing a scenario in the above parallel job when we do a full pull

(to_date('#$ABC#', 'ddmmyyyy')-#$XYZ#);

when we pass 10 or less to XYZ, the jobs runs successfully, but when we pass in higher values like 500 or 1000 the job aborts with the error "Parallel job reports failure (code 13)"

Can anyone help us to understand this isue.

[techiexavier]

To add some more details,

Source i have as Teradata. From the error code i can understand it is related to incorrect timestamp issue. But when i pass the smaller values it runs fine.

I checked the source DB it has data for past 6 years. Please help me how to fix this issue.