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 APRIL 04, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms