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

Last updated on JULY 12, 2012

Applies to:

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


Symptoms

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.

example:

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)

 

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