BBC reporting that the oil pressure loss was caused by a crack internally on the rotor shaft. No idea of the 225's oil flow routing so cannot expand.
Out of interest, what does the 'SHOT' caption indicate?
It's French for 'FU@@ED'.
More onthe story here.
BBC News - Bond Super Puma ditching caused by gearbox crack