My Oracle Support Banner

Transactions Workbench Issue: After the Customer Merge the BILL_TO_SITE_USE_ID in RA_CUSTOMER_TRX_ALL and CUSTOMER_SITE_USE_ID in AR_PAYMENT_SCHEDULES Are Not Updated Correctly (Doc ID 2004214.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Receivables - Version 12 and later
Information in this document applies to any platform.

Symptoms

After the customer merge, there are 2 corruptions:

Pattern 1 - Transactions having the customer_site_use_id of the ar_payment_schedules Table And Details on zx_lines_det_factors Table are Incorrect

Pattern 2 - Transactions having the bill_to_site_use_id of the ra_customer_trx Table, customer_site_use_id of the ar_payment_schedules Table And Details on zx_lines_det_factors Table are Incorrect

In both the patterns the zx_lines_det_factors is not at all updated during the customer merge.

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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 5. Identify Possible Data Corruption
 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.