My Oracle Support Banner

(Web ADI) Flagged Records Successfully Uploaded Remain Flagged If Some Records Fail Validation. (Doc ID 2663546.1)

Last updated on APRIL 27, 2020

Applies to:

Oracle Web Applications Desktop Integrator - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.


On : 12.0.0 version, MICC Transfer to TSC


It appears that standard functionality of WebADI in R12 is that after upload attempt, any records that PASS validation will REMAIN flagged if other records FAIL validation.

The desired behavior is that after upload attempt, records that PASS validation are UN-FLAGED, while records that FAIL remain flagged.

The customer is seeing that their (Web ADI) Flagged records successfully uploaded remain flagged if some records fail validation.

When uploading records with Web ADI spreadsheet, if some of the records fail validation while others pass, the upload flags remain on all records.

The expectation is that records should be un-flagged if they pass validation.

Business may want to upload thousands of records and if there is a failure, they only want the records that failed to remain flagged so that they don't have to manually un-flag the successful records for the next upload attempt. Not unflagging the successful records before the second upload attempt will create duplicate records in Oracle if the first upload was unsuccessful.


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

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