Why do I get an error "SELF_REFERENCE_FROM_TRIGGER" with Subscription/Account Subscriptions or Recurring Payments updates?
When the Status on a (A) Recurring Payment OR a (B) Subscription/Account Subscription and update occur where the related records status is kept in sync with each other.
Should you have a Flow or similar that also does updates, then this can cause a recursive update.
For example, if you have a Flow that is trigger off the Subscription that updates related Recurring Payments. Then on a Recurring Payment, you change the status, the related Subscription/Account Subscription status is also updated. That in turn triggers your Flow to run that tries to update the source Recurring Payment and this is when you will get the error.
The simplest fix is to change your Flow on the Entry step to run "Asynchronously "