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)
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”bne:text=”Validation failed.”bne:cause=”Debit must be a numeric value.”
STEPS TO REPRODUCE
- WebAdi responsibility > Create Document
- Enter data using the indicated formatting for numbers (Debit and/or Credit)
- Attempt to upload
- Get error on the screen
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.
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