Reporting - EBS (MOSC)

MOSC Banner

Error messages getting appended in WEBADI for duplicate error rows

edited Jul 15, 2016 5:04AM in Reporting - EBS (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center