EDD Returns Duplicate Columns Due to Synonym Usage in Cross-Schema Tables
(Doc ID 3065096.1)
Last updated on DECEMBER 30, 2024
Applies to:
Oracle Financial Services Data Integration Hub - Version 8.1.2 and laterInformation in this document applies to any platform.
Symptoms
On : 8.1.2 version, Install Issues_OFSS
ACTUAL BEHAVIOR
---------------
While defining the EDD on a data source schema in Oracle database, when users select a table and retrieve columns, the same column appears three times for every column in the source table.
EDD returns duplicate columns after fetching the table.
EXPECTED BEHAVIOR
-----------------------
After retrieving the columns from the table, no duplicate columns should appear in the EDD definition screen.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot define or create EDDs.
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 |
| References |