ORA-01403 NO DATA FOUND ERROR WHEN REFRESHING QUERY IN MATERIAL DISTRIBUTIONS
Hi
We are receiving NO DATA Found error in Inventory module when querying some transactions (when refreshing query) since yesterday.
Aslo a user infromed that screens freezed while processing sales order on the Order Management module.
I dont think it is a patching issue etc as there has not been change recently.
I have asked advise to my colluege (DBA) , he suspects that that some big select statements run on the instance, as the UNDO TABLE space in not flashed (keep getting bigger, 98% used)
Can anyone confirm if the above table space being more less full can cause such errors on the application/front end.