Domain-only Load Plan execution failed with the error: ODI-40444: Column not found

(Doc ID 2224219.1)

Last updated on APRIL 10, 2018

Applies to:

Oracle Transactional Business Intelligence Enterprise for Human Capital Management Cloud Service - Version 11.1.10.0.0 and later
Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

After following the below documentation for initial configuration of OTBI-E, the Domain-only Load plan failed with the below errors at various steps:
Documentation link: https://docs.oracle.com/cloud/latest/otbie_gs/BITIG/GUID-F7A65EFB-2ED7-4E3B-B8F8-2A6AD35D5011.htm#BITIG-GUID-F7A65EFB-2ED7-4E3B-B8F8-2A6AD35D5011


ODI-1226: Step FTS_FUSION_HcmTopModelAnalyticsGlobalAM.PersonsDFFBIAM.FLEX_BI_PersonsDFF_VI fails after 1 attempt(s).
ODI-1240: Flow FTS_FUSION_HcmTopModelAnalyticsGlobalAM.PersonsDFFBIAM.FLEX_BI_PersonsDFF_VI fails while performing a Loading operation. This flow loads target table HcmTopModelAnalyticsGlobalAM.PersonsDFFBIAM.FLEX_BI_PersonsDFF_VI.
ODI-1227: Task SrcSet0 (Loading) fails on the source FILE connection EXT_STORAGE__FUSION_10_0__1001.
Caused By: java.sql.SQLException: ODI-40444: Column not found: ACCRUAL_DATE_

 

ODI-1226: Step FTS_FUSION_HcmTopModelAnalyticsGlobalAM.BaseWorkerAsgDFFBIAM.FLEX_BI_BaseWorkerAsgDFF_VI fails after 1 attempt(s).
ODI-1240: Flow FTS_FUSION_HcmTopModelAnalyticsGlobalAM.BaseWorkerAsgDFFBIAM.FLEX_BI_BaseWorkerAsgDFF_VI fails while performing a Loading operation. This flow loads target table HcmTopModelAnalyticsGlobalAM.BaseWorkerAsgDFFBIAM.FLEX_BI_BaseWorkerAsgDFF_VI.
ODI-1227: Task SrcSet0 (Loading) fails on the source FILE connection EXT_STORAGE__FUSION_10_0__1001.
Caused By: java.sql.SQLException: ODI-40444: Column not found: DESC_INDUSTRY_CODE_

Cause

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