This content has been marked as final. Show 4 replies
you can check if the record already exists in the target table, if so raise an exception in your code.
Transactions issued by webADI live in the same oracle session.
Thanks for your update.
I can do that but my requirement is if I enter duplicate entries in excel sheet I need to validate that ?
How can I do that?? Please advise..
you can use a global table variable.
each time at the very beginning of your API you check if in the global table variable there is already the PO Ref Num.
if so, raise an exception.
if not, you add the PO Ref Num to your global table variable.
you can use a temporary table which created by yourself.
In API procedure you should check the data with this table first,
if have then raise an exception,if no then insert the record into the table.