My Oracle Support Banner

12.2 E-Business Suite Web Applications Desktop Integrator Upload Error 'VALIDATION FAILED' When BNE: Enable OOXML Standards profile = Yes And Date is Referenced from Another Worksheet Or When Column Data Contains A Comma (Doc ID 2354597.1)

Last updated on JULY 27, 2020

Applies to:

Oracle Web Applications Desktop Integrator - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.2 Web Applications Desktop Integrator, Web ADI related issues

 

 

 

If the BNE: Enable OOXML Standards profile = Yes, the WebADI upload fails when a cell in Excel is a Date and the date is imported/referenced from another excel worksheet.

Also Webadi Upload fails when Debit & Credit columns having comma and users are getting error Message as 'Validation failed', even it doesn't say which column has failed.

Note if there is any validation failure, its just give the Error Message as 'Validation failed', it does not say which column and what error.

Previously it used to work fine when we have BNE OOXML Profile set to 'No'.

If they disable the profile option and create templates, its allowing to upload number with commas, also for validation failure it gives the proper error message.

 

Changes

 Upgrade to 12.2.6

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


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