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 APRIL 08, 2024

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:

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.