Paying Customer Details Cannot Be Changed on AR Transactions due to error: ORA-20001: Could not recreate payment schedules because the transaction has an activity against it (Doc ID 2614034.1)

Last updated on APRIL 03, 2023

Applies to:

Symptoms

On : 11.13.19.04.0 version, Billing - Transactions

When the user changes the Paying customer and then press Save on the transaction, the following error is showing:

ERROR
-----------------------

ORA-20001: Could not recreate payment schedules because the transaction has an activity against it. Contact your system administrator. ORA-06512: at "FUSION.ARP_PROCESS_HEADER_POST_COMMIT", line 1077 ORA-06512: at "FUSION.ARP_PROCESS_HEADER", line 1823 ORA-06512: at "FUSION.ARP_PROCESS_HEADER", line 2848 ORA-06512: at line 1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a transaction with an account for Bill-to and another Account for Paying Customer
2. Change the Paying Customer details
3. Save > notice the error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the invoices can't be payed

Cause

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