'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 laterInformation 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
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
| Symptoms |
| Cause |
| Solution |