Conditions for Setting the DTC
WARNING: This page is about a different car, the 2004 Pontiac Vibe. However, it is still accessible from the selected car via links, so may be relevant.
DTC P0974 sets when either of the following conditions occurs:
The PCM detects an open in the shift solenoid #1 circuit when the solenoid is commanded OFF.