FRM-40735: POST QUERY trigger raised unhandled exception ORA-01403 when query in the Invoice Workben
The issues first began when the batch was terminated. When AP resubmitted the batch, they remove that payment from the batch and tried running it through again, which then gave them another error "Cancelled - No Invoices Selected".
A diagnostic report was ran to see if we could find the cause. Attached is a copy of the diagnostic report as well as a screenshot of the error. Looks like from the diagnostics report that was run, they voided the original payment on 5/12. I wonder if the bank account inactivated as of the 11th. might have something to do with it. We had them change the dates on both the new and old bank account as well as remove them to see if perhaps that would cause the issue with quering the supplier in the workbench. That did not work.