My Oracle Support Banner

'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 FEBRUARY 20, 2023

Applies to:

Oracle Healthcare Analytics Data Integration - Version 2.0.2 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.


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.