Skip to main content
Question

Refresh Language cache return ORA-01422: exact fetch returns more than requested number of rows. Information Card. CONFIG

  • May 2, 2024
  • 0 replies
  • 294 views

Forum|alt.badge.img+2

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).

Refresh Language Cache

then 

Error

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!