Error: E-SY025: FRM-40509: ORACLE error: unable to UPDATE record. - Batch Detail Entry pledge schedule

When adjusting the payment amount on a PP (Pledge Payment) for an IN (Individual) pledge that has a pledge schedule, and after changing the payment amount in batch, you may get the following error when you zoom in on the IN Gift Kind and go to the Schedule or Reconciliation tabs of the Installment Maintenance window:
 
Error: E-SY025: FRM-40509: ORACLE error: unable to UPDATE record.
This may occur when there is a record in the Pledge Schedule Payments table that does not line up with the correct transaction record. This can occur when you have previously adjusted the gift date on a PP - the pledge schedule payment record remains associated with the old gift date instead of the payment on the new gift date.

TA Support has a script that can rebuild the pledge schedule payments to match the existing transactions, so if you encounter this issue contact TA Support for assistance.

Environment

 TA
 RSR

Was this article helpful?