Are you using the latest version of Bitcoin Core?
Can you share the receiver's address here and the address where the bitcoin comes from?
Some block explorer doesn't recognize any transaction with low fees like blockexplorer.com according to this
post.
I don't have much knowledge on using this wallet but let me try to help you.
I found some old post here that I think will help you to remove the transaction and make a new one instead.
Follow the guide below.
You can manually remove the transactions from Bitcoin Core:
-Exit Bitcoin Core
-Backup your wallet.dat, even though you should have a backup already, make another backup
-Start Bitcoin Core from a command prompt with options -zapwallettxes -rescan (if you're using a pruned wallet, you can't use this)
Depending on your hardware, it will take a few hours to rescan. After this, your transactions should be gone, but Bitcoin Core might pick them up from mempool again. In that case just wait for it to drop again.
Full description of the commands:
-zapwallettxes=<mode>
Delete all wallet transactions and only recover those parts of the
blockchain through -rescan on startup (1 = keep tx meta data e.g.
account owner and payment request information, 2 = drop tx meta
data)
-rescan
Rescan the block chain for missing wallet transactions on startup
Credited to
LoyceV