Custom WebADI Integrator Using Procedures Based Interface Is Inserting Rows Even If the Upload Process Is Failing: '< > row(s) failed validation, and 0 row(s) successfully uploaded'
(Doc ID 3028449.1)
Last updated on JULY 31, 2024
Applies to:
Oracle Web Applications Desktop Integrator - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
A new custom WebADI integrator was built, making use of the 'BNE commit rows' parameter feature and using a custom interface that is procedure-based with no Commit action included. On uploading the data, the 'Commit rows' selection is 'All', since this ensures one Commit is enforced only, at the end of all validations.
The expectation is that, based on the procedure's definition, in case of failure no data will be uploaded and the whole process would rollback. On uploading though, even if some rows fail validation and an error is displayed on the screen, the correct rows are still being inserted in the interface.
ERROR
The upload process has completed with the following status:
< > row(s) failed validation, and 0 row(s) successfully uploaded
STEPS TO REPRODUCE
1. Desktop Integration Manager responsibility > Create Integrator
2. Create a custom integrator to insert data into a custom table interface using a procedure
3. Make sure the Commit is set after 'All Rows' in the definition
4. Desktop Integrator responsibility > Create Document
5. Fill in all the data in the spreadsheet > Upload spreadsheet data
6. Get an error on the screen7. Verify the data is still inserted in the table
Changes
New setup in place.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |