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