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 DECEMBER 03, 2021

Applies to:

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


On Oracle Business Intelligence Application (OBIA) V,

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.


Data Source Upgraded From Fusion R12 to Fusion R13


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

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