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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.