FRM-40735: DO_FORCE_APPROVAL trigger raised unhandled exception ORA-01422.
Hi fellow sufferers,
Running EBS 12.1.3.
I have a large base of users accessing and using AP on the same instance in several orgs.
I have (at least) three users in various orgs that are experiencing the following error if they manually overwrite the approvals process in AP Workbench (Actions->Manual)
FRM-40735: DO_FORCE_APPROVAL trigger raised unhandled exception ORA-01422.
They can carry on, the invoice is marked Manually Approved but the Approvals History is not updated correctly. This will happen without exception with these three users, irrespective of what computer they log in from. I have also had other users log in using the problem-user computers and they can manually approve with no issues.