My Oracle Support Banner

OBIA 11g: FA13.18.02 upgrade ETL Extract Error: ODI-40444: Column not found: APPLICATIONID (Doc ID 2418338.1)

Last updated on JULY 05, 2018

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.1 to 11.1.1.10.2 [Release 11g]
Information in this document applies to any platform.

Symptoms

When customer upgrades from FA 13 to FA13.18.02 ETL Extract  Fails with Error: ODI-40444: Column not found: APPLICATIONID

1. Error: ODI-40444: Column not found: APPLICATIONID
SDE_FUSION_11_ADAPTOR_FTS_FUSION_HCMTOPMODELANALYTICSGLOBALAM_PERSONNAMEDFFBIAM_FLEX_BI_PERSONNAMEDFF_VI
SDE_FUSION_11_ADAPTOR_FTS_FUSION_HCMTOPMODELANALYTICSGLOBALAM_POSITIONCUSTOMERFLEXBIAM_FLEX_BI_POSITIONCUSTOMERFLEX_VI
SDE_FUSION_11_ADAPTOR_FTS_FUSION_HCMTOPMODELANALYTICSGLOBALAM_VISAPERMITDFFBIAM_FLEX_BI_VISAPERMITDFF_VI
SDE_FUSION_11_ADAPTOR_FTS_FUSION_HCMTOPMODELANALYTICSGLOBALAM_GRADECUSTOMERFLEXBIAM_FLEX_BI_GRADECUSTOMERFLEX_VI
SDE_FUSION_11_ADAPTOR_FTS_FUSION_HCMTOPMODELANALYTICSGLOBALAM_CITIZENSHIPDFFBIAM_FLEX_BI_CITIZENSHIPDFF_VI
SDE_FUSION_11_ADAPTOR_FTS_FUSION_HCMTOPMODELANALYTICSGLOBALAM_JOBCUSTOMERFLEXBIAM_FLEX_BI_JOBCUSTOMERFLEX_VI
SDE_FUSION_11_ADAPTOR_FTS_FUSION_HCMTOPMODELANALYTICSGLOBALAM_PERSONDETAILSDFFBIAM_FLEX_BI_PERSONDETAILSDFF_VI
SDE_FUSION_11_ADAPTOR_FTS_FUSION_HCMTOPMODELANALYTICSGLOBALAM_BASEWORKERASGDFFBIAM_FLEX_BI_BASEWORKERASGDFF_VI
SDE_FUSION_11_ADAPTOR_FTS_FUSION_HCMTOPMODELANALYTICSGLOBALAM_RELIGIONDFFBIAM_FLEX_BI_RELIGIONDFF_VI
SDE_FUSION_11_ADAPTOR_FTS_FUSION_HCMTOPMODELANALYTICSGLOBALAM_PERSONSDFFBIAM_FLEX_BI_PERSONSDFF_VI

2. Error: ODI-40444: Column not found: ACA_FULL_TIME_
SDE_FUSION_11_ADAPTOR_FTS_FUSION_HCMTOPMODELANALYTICSGLOBALAM_BASEWORKERASGLEGDDFBIAM_FLEX_BI_BASEWORKERASGLEGDDF_VI

3. Error: ODI-40444: Column not found: AAP_
SDE_FUSION_11_ADAPTOR_FTS_FUSION_HCMTOPMODELANALYTICSGLOBALAM_LOCATIONCUSTOMERFLEXBIAM_FLEX_BI_LOCATIONCUSTOMERFLEX_VI

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.