During AP Invoice Purging, data moved to ap_history_invoices_all table but the same data was not del
For one of my users, during AP Invoice Purging in one specific TEST instance, data moved to 'ap_history_invoices_all' table but the same data was not deleted from 'ap_invoices_all' table. During preliminary iterations in other TEST instance, this issue did not occur.
I could not find any MOS documents or bugs for such issue.
Ran below delete script for organization facing issue (data not getting purged)
delete from ap_history_invoices_all where purge_name in ('ABCD', '1234');
Reinitiated purging process for few Orgs and found that the data is getting purged from ap_invoices_all table.