'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.


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:


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.


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