Webadi - 'Entered Amounts For Journal 1 Are Not Balanced' on Uploading Excel with Huge Numbers (More Than 15 Digits) (Doc ID 1469682.1)

Last updated on JUNE 27, 2016

Applies to:

Oracle Web Applications Desktop Integrator - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Oracle General Ledger - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

A journal was created to be uploaded to General Ledger through WEBADI. The amounts are huge, having more than 15 digits (scientific numbers).

The journal looks balanced but when attempting to upload, the following error occurs:

Error
-----
'Entered amounts for Journal 1 are not balanced'

Similar issue has been faced but in a different circumstances so it worth to be checked before going further with the below solution:
- carefully review the batch name and Journal Name for each Journal Line to ensure it is the same within a balanced journal

Batch Name can be different for *ONE Journal Line* in a batch with 3 different currencies and many JE Lines.

Changes

 Used large (scientific) numbers in the spreadsheet.

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