My Oracle Support Banner

12.2.5 Validation Failed Error ('must be a numeric value') - Debit / Credit Fields Via WebAdi (Doc ID 2245411.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle Web Applications Desktop Integrator - Version 12.2.5 to 12.2.6 [Release 12.2]
Oracle General Ledger - Version 12.2.5 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.
Web Applications Desktop Integrator (WebAdi)



Symptoms

When uploading journals with WebAdi, the Debit and Credit amounts must be formatted as "General". If the Debit and/or the Credit amounts are formatted as "Number" or "Accounting" in Excel, a "Validation Failed" error message displays.


ERROR
”ERROR”bne:text=”Validation failed.”bne:cause=”Debit must be a numeric value.”

STEPS TO REPRODUCE

  1. WebAdi responsibility > Create Document
  2. Enter data using the indicated formatting for numbers (Debit and/or Credit)
  3. Attempt to upload
  4. Get error on the screen

Changes

 Profile option 'BNE: Enable OOXML Standard' is set to 'Yes' at the Site level.  If this profile is set to 'No', the issue is resolved but it creates an additional blank Excel document when publishing.

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.