2008 Nissan Altima is showing code p0746? on 2008 Nissan Altima

My car is showing code p0746, I had the transmission flushed and all new fluid yesterday, but check engine light is still on. Nissan told me I needed a whole new transmission, the car has 130k miles so its over warranty, but a mechanic told me I should just be able to order a pressure control solenoid and have it replaced, anybody else have this issue and know how to fix it?

Asked by for the 2008 Nissan Altima
seek free diag and est from aamco then shop prices