Update Transaction Revenue Distribution Creates Unbalanced ACCTD_AMOUNT (Functional Amount)
Last updated on JULY 12, 2012
Applies to:Oracle Receivables - Version 220.127.116.11 to 18.104.22.168 [Release 11.5.10]
Information in this document applies to any platform.
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)
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