AP Invoice Approval Workflow - Multiple active WF processes active for same invoice at the same time
Good Morning,
We recently had encountered an issue where there were multiple active workflow processes of AP Invoices Approval workflows - For the same invoice. This had created confusion, multiple active notifications were generated, some notifications where user approved the invoices, were still not completed and the corresponding invoices were still shown as 'INITIATED'. I reviewed the AP Invoices archive table data but could not understand the sequence and how the issue occurred.
Need assistance on finding out
1. How and when this type of scenario could occur
2. I have seen in the ap_invoices_all_a (audit table) that there were multiple rows with wfapproval_status as 'INITIATED' values, and one row with REJECTED too. How to follow the sequence of steps happened by reviewing the data in this table. When I sorted data in this audit table with the "order by audit_sequence_id asc", this seems to be not following the actual sequence and audit_timestamp dates are all over. Shall I sort by the audit_timestamp dates itself to understand which sequence occurred first and which one after?