Can there be intelligence written with cancel button/process in webADI
Hi ,
We are trying to load the records on webADI template upload to a staging table from where up on completion of validation and processing the records would be picked up by concurrent program for loading into EBS. this process works fine if user does not cancel the upload process intermittently.
If the user cancels this upload process intermittently or if there is any data validation error in the middle row of template data, the records that were processed upto cancellation or error record are getting stuck in the staging table. The problem is these records are getting processed on next successful upload of webADI template and this is causing data discrepancy.
We are trying to load the records on webADI template upload to a staging table from where up on completion of validation and processing the records would be picked up by concurrent program for loading into EBS. this process works fine if user does not cancel the upload process intermittently.
If the user cancels this upload process intermittently or if there is any data validation error in the middle row of template data, the records that were processed upto cancellation or error record are getting stuck in the staging table. The problem is these records are getting processed on next successful upload of webADI template and this is causing data discrepancy.
0