Purdue and RPI have both achieved this. RPI was second, but had better instruments.
It is not technically cold fusion. The collapsing bubble creates a high temperature and pressure spot, but it is small enough that it doesn't provide enough boom to destroy the can.
They used deuterinated acetone as the working fluid. That is standard acetone chemically, but with the standard single proton hydrogen replaced with deuterium, a proton and a neutron. As the bubbles form in the low pressure region of the sound wave the acetone evaporates, then in the high pressure region the bubbles collapse.
It acts a bit like the military shaped charges, with the edges of the bubble adding vectorally. The tiny center of the collapsed bubble is hit with neutrons while at high pressure and temperature, and you get helium (two protons and one neutron) out with a bit of energy.
Helium will not stay bonded to the rest of the acetone, so you have a tendency of the acetone to poison itself after operating for a bit.
Some folks are working on turning this into a powerplant. The previous cold fusion work (in Utah) was a rediscovery of the Alverez effect.
There is a claim of a process that goes beyond this, and their is a company seeking capital to exploit both. Some question whether they are nothing more than a scam however.
I have lost the details but boot hill may remember.