Hi,
We got error "ORA-01422: exact fetch returns more than requested number of rows” when we trying to Refresh Language Cache in IFS EE client (APP10 UPD9).
then
Error Stack:
Ifs.Fnd.FndSystemException: Unexpected error while calling server method ManageInstalledModules/RefreshLanguageCacheOnline ---> Ifs.Fnd.FndServerFaultException: ORA-01422: exact fetch returns more than requested number of rows
Failed executing statement (ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "IFSAPP.LANGUAGE_CONTEXT_API", line 2108
ORA-06512: at "IFSAPP.LANGUAGE_CONTEXT_API", line 2122
ORA-06512: at "IFSAPP.LANGUAGE_SYS", line 1972
ORA-06512: at "IFSAPP.LANGUAGE_SYS", line 2100
ORA-06512: at "IFSAPP.LANGUAGE_SYS", line 2100
ORA-06512: at "IFSAPP.LANGUAGE_SYS", line 2119
ORA-06512: at "IFSAPP.LANGUAGE_SYS", line 2133
ORA-06512: at "IFSAPP.LANGUAGE_SYS", line 1848
ORA-06512: at line 1)
We found above records causing the problem.
This is the Information card we add.
Anyone familiar with this error before or any suggestion how to fix this.
Thanks!