My Oracle Support Banner

OBIA 11g : BICC Extract to SDS table At Create Work Table Step Is Failing With Error "ORA-00904: Invalid Identifier" (Doc ID 2424694.1)

Last updated on NOVEMBER 19, 2020

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.2 and later
Information in this document applies to any platform.

Symptoms

On Oracle Business Intelligence Application (OBIA) V 11.1.1.10.2,

Customized the interface FTS_FUSION_HcmTopModelAnalyticsGlobalAM.AssignmentAM.AssignmentStatusTypesTranslationPVO that populates the HCM_AS_SSGNMNTSTTSLTNPV947155 SDS table from the BICC extract file (FTS_FUSION_HcmTopModelAnalyticsGlobalAM.AssignmentAM.AssignmentStatusTypesTranslationPVO).

While run the above interface, the following error appears at Create Work Table step -

Note : The error is observed when LKM BIAPPS CLOUD VO File to SQL is used to execute the interface in ODI and deliver the data from the VO to the target table.

Changes

Data Source Upgraded From Fusion R12 to Fusion R13

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
Changes
Cause
Solution
References


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