Invoice BPM workflow rules migration and related problems

Summary:

We have recently migrated Invoice BPM workflow rules, and the code is working fine for the freshly created Invoices, however, this migration broke all the inflight Invoice Approvals.

For all the in-flight invoice approvals - respective invoice approvers were unable to approve them.

The only option to resolve this is to withdraw and resubmit Invoices to make sure the approvals are re-triggered again, and approvers can act on them.

Unfortunately, the solution ORACLE recommended is as below:

Keep all the invoices in a fully approved state and then migrate the code, this is impossible for us with more than 600 invoices per day with multiple channels for incoming invoices [ Supplier Portal, OBN, Just Transform, manual invoice loads, and integration-based loads]