My Oracle Support Banner

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 FEBRUARY 01, 2022

Applies to:

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


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:




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.