OWB Process Flow Execution Fails With ORA-01841: (Full) Year Must Be Between -4713 And +9999, And Not Be 0 (Doc ID 472973.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 10.2 and later
Information in this document applies to any platform.

Symptoms

A mapping has a DATE value as input parameter.
Mapping Deployment and Execution are successful.
This mapping is added to a Process Flow.
The Process flow Deployment is successful.

When clicking on the START button to execute the Process Flow, the following error message comes up instead of Input Parameter screen:
- ORA-01841: (full) year must be between -4713 and +9999, and not be 0
ORA-06512: at "OWBSYS.WB_RT_CONVERSIONS", line 122
ORA-06512: at "OWBSYS.WB_RT_CONVERSIONS", line 171
ORA-06512: at "OWBSYS.WB_RT_CONVERSIONS", line 292
ORA-06512: at line 1
ORA-06512: at "OWBSYS.WB_RT_TASK_VARIABLE", line 718
ORA-06512: at "OWBSYS.WB_RTI_EXECUTION", line 712
ORA-06512: at "OWBSYS.WB_RTI_EXECUTION", line 859
ORA-06512: at "OWBSYS.WB_RT_EXECUTION", line 14
ORA-06512: at line 1

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms