ORA-01843 Error In DMA Installation For ODI
Last updated on AUGUST 07, 2017
Applies to:Oracle Healthcare Foundation - Version 7.1 and later
When installing OHF 7.1.x, after successfully installed Oracle Client, Oracle Healthcare Foundation Data Model 7.1.x, JDK, Oracle Data Integrator, not able to install DMA for ODI.
For example, when running PKG_HCD_W_HCD_USER_D_INCREMENTAL ETL fails at step 10 - Int_HDM_USER_W_HCD_USER_D -> 28 - Integration - Int_HDM_USER_W_HCD_USER_D - Insert flow with ORA-01843: "This is not a valid month" error.
The queries from ODI tasks are working fine in SQL Developer as well as in SQLPLUS from LINUX.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms