ORA-01422: exact fetch returns more than requested number of rows
On Invoice workbench, when user trying to match with a PO, she gets the error:
ORA-01422: exact fetch returns more than requested number of rows
--------------------------------------------------------------
FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01422.
The PO is seemingly valid. The only special thing about this PO is it was created in 'EUR' and later on changed to 'GBP'.
For this supplier, we do not have any foreign pay site. But that should not stop us from creating the invoice, as we do with many other
similar Purchase Orders.
Any help or pointers to solve this issue is hight appreciated.
Tagged:
0