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

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

Cause: The USERENV( COMMITSCN ) function can only be used once in a transaction.

Action: Re-write the transactioin to use USERENV( COMMITSCN ) only once