Ksh tips

#set -o vi

Scroll up -> ESC+k

Scroll down -> ESC+j

Auto finish -> ESC+\

FRM-40509: ORACLE error: unable to UPDATE record.

environment:

error message:
FRM-40509: ORACLE error: unable to UPDATE record.
------------------------------------------------
ORA-20160: ORACLE error -4091 in SUBMIT: others

Cause: SUBMIT: others failed due to ORA-04091: table APPLSYS.FND_USER is mutating, trigger/function may not see it.

The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE,
ORA-06512: at "APPS.ALR_FND_USER_USR", line1
ORA-04088: error during execution of trigger 'APPS.ALR_FND_USER_UAR'

solutions: