My Oracle Support Banner

Upload Fails When Credit and Debit Columns Format Is Changed With Profile BNE: Enable OOXML Standard Set To Yes (Doc ID 2248401.1)

Last updated on FEBRUARY 22, 2019

Applies to:

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

Symptoms

On : 12.2.6 version, WebADI Templates

Comma Separator in Excel template errors

When we paste information into the new WebADI templates from 12.2.6, the upload errors due to the format in excel of the numbers.

If you take out the "," separator, the file uploads.

Can use Number format or General, however cannot use the comma separator or the file errors.

bne:cause="Debit must be a numeric value."

The issue can be reproduced at will with the following steps:
1. Add information to Web ADI Integrator Template that has a Comma Separator for GL.

Due to this issue, Web ADI GL Budget Integrator is not working as expected.

Changes

 BNE: Enable OOXML Standard is set to "Yes" @site level

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.