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 11.1.1.10.2 and laterInformation 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 |