Update Transaction Revenue Distribution Creates Unbalanced ACCTD_AMOUNT (Functional Amount)
(Doc ID 737465.1)
Last updated on OCTOBER 26, 2020
Applies to:Oracle Receivables - Version 18.104.22.168 to 22.214.171.124 [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)
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