My Oracle Support Banner

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

Last updated on MAY 15, 2018

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

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
Symptoms
Cause
Solution
 Still Have Questions?
References


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