Oracle Error ORA-01725: USERENV(‘COMMITSCN’) not allowed here

Oracle Error Message

ORA-01725: USERENV(‘COMMITSCN’) not allowed here

Reason for the Error

The function USERENV(‘COMMITSCN’) is only allowed as a top-level expression in the VALUES clause of an INSERT statement, and on the right-hand side of an assignment in an UPDATE statement.

Solution

Correct the use of the function.