My Oracle Support Banner

Update Transaction Revenue Distribution Creates Unbalanced ACCTD_AMOUNT (Functional Amount) (Doc ID 737465.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Receivables - Version to [Release 11.5.10]
Information in this document applies to any platform.
Unposted Items
General ledger transfer


Transactions (Invoices) are failing GL Transfer.

Original revenue rows are balanced in amount and acctd_amount columns, but when the revenue distribution is updated, the new rows have unbalanced acctd_amount.

When the revenue percent is split, the first row created has 0 acctd_amount and second row has original acctd_amount.


original REV row created at 100%

amount = 1000, acctd_amount = 1000

updated REV row to split between two accounts

amount = -1000, acctd_amount = -1000 (original reversal)
amount = 500,    acctd_amount = 0         (s/b 500)
amount = 500,    acctd_amount = 1000   (s/b 500)



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.