mac, for whatever reason "back at the ECM" is not seeing/ and/ or displaying the Rev-sensor issue 1) may be the p0500/p0600 suggesting "BAD ECM to TCM communication - that alone may "make" the Rev-sensor LOOK bad to the "system" ( looks like bad to TCM in your case) 2) I have , and I believe you GOTTA get an ATSG (Automatic Transmission Service Group) Svc. manual . Mine TM RE4R01A for my J , maybe similar to your Maxima, in that complex trans flow chart - you see Rev sensor WREAKING HAVOC w/ALL shifting-timing!
I believe these are located EXTERNALLY near the output shaft (it's the shaft speed of trans NOT VSS which is the "other" speed input to the ECM/TCM "SYSTEM" ) - At least NOT usually an internal part . 3) Very,very likely that simply a broken wire , connector not tight or worn or corroded etc. , a wire route to or from ECM/ TCM routes involved which APPEAR to be a faulty Rev-sensor - when ,as the ECM comm. codes say "comm. problem" ? 4) So back to your first assumption of a "conflict of ECM vs TCM self diagnostics " - no real CONFLICT- address the fact of the Rev-sensor comm. / wiring/connector integrity -whatever ,so that the TRANS-DIAGNOSTIC does NOT give that "first long" , indicating Rev-sens. 5) That ATSG manual is INDISPENSIBLE , that ATSG manual INDISPENSIBLE!!!
6) There should be a "field" test, like ohms, on that Rev-sens (an on vehicle test probly).
p.s. ANY intensive testing of wires to & from whatever should always be done w/ battery disconnected. NEVER use a BATTERY(1.5V or 9V) powered "Idiot-Tester" , always use a MULTIMETER's continuity - preferably one with audible tone (they "warble-sounded" upon iffy connections! ) =SAFER , lower voltage/current utilized in a meter
. And usually you will need an additional ,long "traveler" wire for return of testing longer than the meter's leads allow. Amazon has these manuals per your full trans model #