If another transactor initiates but does not submit a transaction, locking up those earnings rows, can I go in and cancel the transaction?

Yes, provided you have row level security to access the transaction, you can either continue or cancel a transaction initiated by another user.