Search notes:

DBMS_TRANSACTION.LOCAL_TRANSACTION_ID

dbms_transaction.local_transaction_id returns the transaction ID of the current session.

This transaction ID allows to query the record in v$transaction which has some information for the session's transaction:

insert …;

select
   *
from
   v$transaction
where
   xidusn || '.' || xidslot || '.' || xidsqn = dbms_transaction.local_transaction_id;

See also