Did you purchase the RX7900XTX from AMD directly or it is a OEM (Gigabyte, MSI, Asus, etc) GPU made card?
See if all the fans on the GPU card turns on for a second or so when you boot up. Generally when BIOS checks the GPU card all the fans turns of for a second or so and then turn off.
Did all the fans turn on at boot up?
Try stress testing the GPU card. When the GPU card starts to get hot or overheating all the fans should be running at maximum rate.
I suggest using OCCT GPU to stress test your GPU card. Keep a close eye on temperatures, Fan speeds and PSU Outputs while testing. You can also run the PSU test just to make sure you don't have any power issues with your PSU.
If the fan still doesn't turn on when the GPU card starts to overheat or the Hot Spot starts reaching it maximum operating temperature of 110c then turn power off and physically rotate the fan that doesn't turn. Do you feel any type of resistance at all or when you spin it fast do you hear any noises.
Compare that with the fan that is working and see if you physically see any difference.
Otherwise if the fan is still under Warranty I suggest you open a Warranty Ticket to see if the GPU needs to be checked and repaired or replaced.