Data Corruption In Ar_adjustments And Ar_payment_schedules Due To Raxtrx (Doc ID 1150842.1)

Last updated on AUGUST 05, 2016

Applies to:

Oracle Receivables - Version: 11.5.10.2 to 11.5.10.2 - Release: 11.5.10 to 11.5.10
Information in this document applies to any platform.

Symptoms



On : 11.5.10.2 version, Transactions Related

There is  a specific set of circumstances whereby an invoice can be
imported into receivables via autoinvoice,  and if that invoice has a commitment applied against it, and that commitment has multiple invoice distributions due to the changing of a GL account after the original distribution has been posted to the GL,  then multiple adjustment records are created in error, and the balance of
the invoice is incorrect, as are the dollar figures on the ar_payment_schedules record.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1) Create a deposit transaction by hand for $10000, specifying GL Account A
on the revenue distribution.
Deposit number 47226
Distributions window
Receivable account 10.00.14200.0000.000000
Revenue account 10.00.23510.0000.000000
2) Complete the invoice

3) Run the General Ledger Interface to transfer the distributions on the
deposit transaction to the GL.

General Ledger transfer program
Verify that the invoice distribution has been posted:
Distributions window
GL posted date 15-MAR-2010

4) Go back to the deposit transaction, go to the distribution, and change
the revenue distribution to GL Account B.
You will see that two new distributions are created, one that reverses the
original revenue
distribution with GL Account A, and a new one that is for GL Account B. The
Deposit transaction now has a
total of four distribution lines. Three are revenue, one is receivables

Receivable account 10.00.14200.0000.000000
Revenue account 10.00.23510.HO93.000000
(Changed segment value, about to save record)
Distributions window
Receivable account 10.00.14200.0000.000000 Amount 10000
Revenue account 10.00.23510.0000.000000 Amount (10000)
Revenue account 10.00.23510.0000.000000 Amount 10000
Revenue account 10.00.23510.H093.000000 Amount 10000

(saved the record, now there are two new distributions, one reversing the
original account line, and then the new one).
Post these transactions to the GL, and repeat steps three and four (changing
and posting distributions)
one or more times until there are at least six distributions total.


Distributions window
Receivable account 10.00.14200.0000.000000 Amount 10000
Revenue account 10.00.23510.0000.000000 Amount (10000)
Revenue account 10.00.23510.H093.000000 Amount (10000)
Revenue account 10.00.23510.H094.000000 Amount (10000)
Revenue account 10.00.23510.0000.000000 Amount 10000
Revenue account 10.00.23510.H093.000000 Amount 10000
Revenue account 10.00.23510.H094.000000 Amount 10000
Revenue account 10.00.23510.H095.000000 Amount 10000

5) Load an invoice transaction through autoinvoice where you populate the
customer_trx_line_id from the deposit transaction
in the ra_interface_lines_all.reference_line_id column. This is to get the
invoice to have the deposit amount applied to it.


Run Autoinvoice

6) Review the invoice transaction that was created. Click on Actions/Adjust
to see that, for some reason,
four commitment lines are now applied against this invoice, that the total
of the adjustments do not add up properly,
and the balance of the invoice is now incorrect.

Adjustments window for invoice 2009090280
Installment
Original Total 250
Balance Total 750
Adjustments 500

Adjustments
Number 19466 Amount (250) account 10.00.23510.0000.000000
Number 19467 Amount (250) account 10.00.23510.H093.000000
Number 19468 Amount (250) account 10.00.23510.H094.00000
Number 19469 Amount 500 account 10.00.23510.H095.000000

Expected results :

--The balance of the invoice in total should be 0, not three times the
invoice amount.
--The sum of total of the adjustments displayed on the adjustments form in
the
adjustments field, should be correct. You can see in our example that the
sum of -250x3+500 should be -250, and not +500.
--There should only be a single adjustment line present, in the amount of
-250, and for the only account combination
which does not have a net zero amount on the original deposit, namely the
10.00.23510.H095.000000 account.
The way the adjustment lines read, the other three accounts are all getting
hit incorrectly  and the H095 combo
is getting hit for twice the negative amount that it should get hit for.
This is incorrect from an accounting standpoint.
Those other accounts were reversed on the deposit and should not be coming
into play on the invoice transaction.

This data is actually shockingly wrong in numerous respects. We have both
inappropriate accounts getting hit, as well as basic math errors showing up on the screen
.
BUSINESS IMPACT
-----------------------
GL is out of balance, the invoices that are affected by this are incorrect.

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