OBIA 11g: SDS Golden Gate Error Out "Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist"
(Doc ID 2220937.1)
Last updated on APRIL 13, 2021
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124 and later
Information in this document applies to any platform.
You have recently configured Golden Gate SDS for Source data loads. You have observed multiple failures on OBIA full data Load Plan.
For example the following steps for EBS Source.
This failure was due to the SQL for this step referencing the following views:
ODI-1228: Task SrcSet0 (Loading) fails on the target ORACLE connection
Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does
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