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 11.2.5.0.000 and laterInformation in this document applies to any platform.
Symptoms
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.
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.
UPDATE aif_source_systems
SET base_language = :BASE_LANGUAGE
WHERE source_system_id = #AIF.p_source_system_id
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 |
| Cause |
| Solution |