Add intra-transaction duplicate position-id check

Add intra-transaction duplicate position-id check #7503