Account Re-Write-Off With Taxes Split Out Sometimes Has Incorrect Amounts (Doc ID 1921447.1)

Last updated on MARCH 29, 2019

Applies to:

Symptoms

On 7.4PS19, AR / WRITEOFF

This is basically the same problem as with the <Note 1546947.1> - Account Write-Off With Taxes Split Out Sometimes Has Incorrect Amountsshown), but with a re-write-off after a partial payment.

The symptom is that while the total of tax and charge in the journal table on the re-write-off entry is correct, the individual elements are incorrect.

Scenario:
-------------
1. Set up flexible item assignment so that tax balance impacts are split out into separate "/item/tax/%" items by jurisdiction.
2. Create an account with some cycle fees
3. Add other charges on the account so that several types of "tax" items are created -- we used telephone usage to do this.
4. Move time forward some months, running billing when appropriate, to a future billing day.
5. Set account status to inactive.
6. Write the account off.
7. Move time forward -- it can be in the same day.
8. Make a partial payment to force a re-write-off.

Expected results after re-write-off
---------------------------------------------
1. The absolute value of the sum of the write-off column of the "tax" items should equal to journal_t.cr_ar_tax_amt on the re-write-off entry.
2. The absolute value of the sum of the write-off column of the "non-tax" items should equal to journal_t.cr_ar_net on the re-write-off entry.

Actual results:
-------------------
The total is correct, but the individual amounts do not agree.

Changes

Cause

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