Insert Into I$ Step Fails For A Connector Containing Group By After Target Mapping
(Doc ID 3006408.1)
Last updated on MARCH 01, 2024
Applies to:
Oracle Financial Services Data Integration Hub - Version 8.1.2 and laterInformation in this document applies to any platform.
Symptoms
Post upgrade of DIH from 812 to 8122. A connector which uses LISTAGG in its derived expression, and a GROUP BY After Target mapping is failing at the Insert Into I$ Step with the error "Caused by: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of row"
Changes
Upgrade to DIH 8122
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 |