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 APRIL 04, 2025

Applies to:

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.

Changes

Cause

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