'ORA-01841: (full) year must be between -4713 and +9999, and not be 0' when attempting to run Load_DIHDWF_INITIAL_LOAD_HDI_ID Interface (Doc ID 1597588.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Healthcare Analytics Data Integration - Version 2.0.0 and later
Information in this document applies to any platform.

Symptoms

On Oracle Healthcare Analytics Data Integration (OHADI) 2.0.2 with HDWF 5.0.2 version,
when attempting to run the Load_DIHDWF_INITIAL_LOAD_HDI_ID and the Int_HDI_ID_HDM_PT_ID
interface, in ODI to load the ID tables, the following error occurs:

ERROR
-----------------------



STEPS
-----------------------
The issue can be reproduced with the following steps:
1. In ODI navigate to "Oracle Healthcare Analytics Data Integration" > "DI_HDWF_INITIAL_LOAD" > "Load_DI_HDWF_INITLAIL_LOAD_HDI_ID" > "Interfaces" > "Int_HDI_HDM_PT_IT".
2. Right click and select "Execute"
3. Click "OK", job submits.

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