Using motor oil you are working to a standard that was discontinued probably 40 years ago. This was back in the day when all manufacturers tried to use a “one size fits all” mantra as regards lubricants.
The preferred oil for any Cat powershift transmission of pretty much any age is now TO-4 spec. SAE30 would be the correct viscosity.
We have a few big shops that run Delo 0w30 engine oil for trans, hydraulics and finals.
Everything from D6 to D10s to 980s, 988s, excavators, Challenger tractors, etc.
Story I was told is it technically meets TO4 specs, and they got CAT to approve it, dunno.
It's quite a bit more expensive than Chwvron Torq Force 30, 5w30 or P66 PowerDrive Arctic 0w20