Oracle Error ORA-01721: USERENV(COMMITSCN) invoked more than once in a transaction

Oracle Error Message

ORA-01721: USERENV(COMMITSCN) invoked more than once in a transaction

Reason for the Error

The USERENV(‘COMMITSCN’) function can only be used once in a transaction.

Solution

Re-write the transactioin to use USERENV(‘COMMITSCN’) only once