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 AUGUST 09, 2018

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.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.