Error in EBS integration - ODI-1227: Task Procedure-EBS Update Source System Base Language-Update base language fails on the source connection EBS_DATA_SERVER
(Doc ID 2880467.1)
Last updated on JULY 06, 2022
Applies to:Hyperion Financial Data Quality Management, Enterprise Edition - Version 184.108.40.206.000 and later
Information in this document applies to any platform.
Data Management (FDMEE) is integrated with Oracle EBS and it works correctly. There is a requirement to change EBS Schema name. After changing the EBS schema name in the Physical schema and Logical schema, the integration is failing with below error.
ODI-1227: Task Procedure-EBS Update Source System Base Language-Update base language fails on the source connection EBS_DATA_SERVER.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
The SQL query where the error occurs is below.
SET base_language = :BASE_LANGUAGE
WHERE source_system_id = #AIF.p_source_system_id
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