Reporting - EBS (MOSC)

MOSC Banner

I have created custom WEBADI which loads data in to satging table and then import API is called . If

edited Feb 7, 2020 9:49AM in Reporting - EBS (MOSC) 4 commentsAnswered

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%'

Tagged:

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