I have created custom WEBADI which loads data in to satging table and then import API is called . If
issue is that even though staging table is populated properly with error message, WEBADI is showing repeated message. Each row shows same message 2-3 times. Also after upload, count of error records is wrong. I uploaded 2 records in excel. It says " 2 records successfully uploaded. out of 2 records, 5 records failed validation".
Error lookup and definition query
select error_message from XXDEN_INV_CLAIM_STAGE_TBL where claim_run_id =$param$.CLAIM_RUN_ID and claim_rec_id =$param$.CLAIM_REC_ID and upper(error_message) like 'ERROR%'
select * from XXDEN_INV_CLAIM_STAGE_TBL where claim_run_id =$param$.CLAIM_RUN_ID and upper(error_message) like 'ERROR%'