We have created a custom web adi integrator. our requirement is as follows
1. when user downloads the spreadsheet he must be able to view the already existing data from the table. This functionality is working
2. whetever new data is created it must be updated in the system. This is working currently.
3. Any column from the existing data must be updated.
This functionality is not working, instead the webadi adds additional row to the table instead of updating the existing row.
Could you please help in resolving this issue?
Since you are mentioning that its an custom WEB ADI i presume that you are using custom PL/SQL package as well for loading.
If thats the case, then you have to check whether the existing record which you are updating is already present in the dataase, if yes then call update API's instead of Create API's.