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 220.127.116.11.2 and later
Information in this document applies to any platform.
On Oracle Business Intelligence Application (OBIA) V 18.104.22.168.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.
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