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
Last updated on SEPTEMBER 19, 2016
Applies to:Oracle Receivables - Version 12 and later
Information in this document applies to any platform.
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.
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