Unless the bike has a shared sump wet clutch, you are likely okay using a gasoline automotive oil if the bike's engine block is water cooled. However, I'm not aware of any motorcycles that use water cooled engines without a shared sump wet clutch setup. Therefore, we're left with motorcycles featuring air cooled engine blocks with either air cooled heads, water cooled heads, or oil cooled heads. In the case of oil cooled heads we are talking some high temps the oil is exposed to, over and above that of typical gasoline car and truck engines. A heavy duty diesel oil must deal with cooling the piston crowns as typical diesel design has oil galleries under the crown. Therefore, diesel oils are built to be more thermally stable than gasoline engine oils and thus are often suitable for air cooled motorcycle engines, even with oil cooled heads.
My Moto Guzzi is an example of a "three hole" oiler, since it utilizes a reactive shaft drive, an automotive style dry clutch, and has separate lubrication circuits for engine, transmission, and final drive. The engine oil circuit includes oil cooled heads and a 2nd oil pump dedicated exclusively to moving oil through the heads and through a rather large oil cooler mounted high on the frame where water cooled bikes typically have the radiator. Gasoline automotive oil would not be suitable due to the oil cooled heads. Heavy Duty Engine Oil (diesel oil) of the proper viscosity would work, if one could be found in a 10W60 which is the viscosity the powertrain engineers who designed the engine say to use. Since that is not a common viscosity for HDEO, I use a JASO MA/MA2 compliant motorcycle specific synthetic 10W60 oil as recommended in the owner manual.