cc,
I checked with my friend that has the twin engine airplane with GO480's on it. He is not only a very experienced pilot, but also a licensed aircraft mechanic. The gearbox is pressure fed from the engine oil system, so it uses engine oil in the airplane application. He uses Aeroshell W100 in the engines which is equivalent to a SAE 50 weight oil. It is also an ashless dispersant oil. It is not a detergent oil. Detergent oils are not approved for aircraft. This is one of the oils that is approved for that engine as of 2005. Some of the very old manuals may say something else.
I am not saying that other oils will not work, but that is what is used in the airplane application.
Jim