ORA-04092: cannot SET NLS in a trigger
EBS 12.2.10
Database 19c (19.18.0.0.0)
I have a custom table on which a customer trigger has been enabled at update event. If any row is updated in table, following error appears:
-20001 ORA-20001: Oracle error -20001: ORA-20001: Oracle error -4092: ORA-04092: cannot SET NLS in a trigger
ORA-06512: at "SYS.DBMS_SESSION", line 204
has been detected in fnd_global.set_nls.set_parameter('NLS_LANGUAGE','AMERICAN').
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_GLOBAL", line 288
ORA-06512: at "APPS.FND_GLOBAL", line 1540
has been detected in fnd_global.set_nls.
-20001 ORA-20001: Oracle error -20001: ORA-20001: Oracle error -4092: ORA-04092: cannot SET NLS in a trigger