All Oracle Error Codes
Oracle DBA Forum
USERENV('COMMITSCN') not allowed here
The function USERNEV('COMMMITSCN') is only allowed as a top-level expression in the VALUES clause of an INSERT statements, and on the right hand side of an assignment in an UPDATE statement.
Correct the use of the function.