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 SEPTEMBER 19, 2016

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

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