I'm not a technician, but here is my IMHO. When one of the modules goes bad, you should get a CEL, thats the whole point of it.
From what i've read, usually whe TCM goes bad, when u try shift from lets say N to P it does the opposite or doesnt do anything. Or starts slipping.
and also here
is a couple of threads about it