Troubleshoot fix resolve ORA-01422: exact fetch returns more than requested number of rows

Error Description: The number specified in exact fetch is less than the rows returned.

Fix for this error: Rewrite the query or change number of rows requested