How To Refresh Party_id In Xla_ae_lines Table When Customer Is Changed In Receipt. (Doc ID 1170833.1)

Last updated on AUGUST 05, 2016

Applies to:

Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.
ARXRWMAI,XLA_AE_LINES,Party_id


Symptoms

In XLA_AE_LINES the Party_id is getting stored for each transaction when the party changes the party id is not refreshed in the transaction level.

In AR, receipts can be posted to XLA with one Customer and if its Unapplied, the Receipt Customer name can be changed at any time.

1. Now you create a Receipt with Customer A in Unapplied status and then posted the receipt.
2. Then you change the Customer name to Customer B and applied a transaction against it. Again posted the receipt.

The lines [data in xla_ae_lines] for Step 1 has the reference to Customer A and the lines [data in xla_ae_lines] for Step 2 has the reference to Customer B.

If a receipt is remitted, and is in an unapplied status, and then the customer's information is changed, then the XLA records should also be updated.

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