Error messages getting appended in WEBADI for duplicate error rows
I have developed an Integrator conatining table type interface and PL/SQL type importer. Now when we are providing duplicate values in the columns that identify the uniqueness of each row in importer, we are getting back error messages from both the rows, appended to each other and this error message appears only at the last line of the duplicate row.
Example given below :
Interface type : Table type
Importer : PL/SQL API
Document row mapping : Column A, Column B, Column C
Error row definition : select * from table X where status = 'ERROR'
Error Definition lookup : Select messages from table X where columnA = $PARAM$.columnA and columnB= $PARAM$.columnB and columnC = $PARAM$.columnC