R12 AGIS Webadi Upload Fails With "Ensure The Sum Of All The Initiator Distributions Does Not Exceed The Transaction Amount" (Doc ID 1304155.1)

Last updated on JANUARY 08, 2016

Applies to:

Oracle Financials Common Modules - Version 12.1.1 and later
Oracle General Ledger - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version,

When entering multiple distributions with mixed positive and negative amounts for the same transaction using WebADI, following error message is displayed in the message

This message appears specifically if the Credit or Debit have negative values in the last row of webadi spreadsheet

ERROR
-----------------------
"Ensure the sum of the all initiator distributions does not exceed the transaction amount.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create AGIS WebADI template.
2. Enter Initiator and distribution lines with positive and negative amounts in such a way that Initial lines add up to more than the DR/CR amount in the header and then negative lines in last lines, so that the overall sum of the initiator lines equal to the transaction amount in header.
3. Now Upload the spreadsheet , it fails with error message "Ensure the sum of the all initiator distributions does not exceed the transaction amount"

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