IMO, you should always be allowed to return to your previous seat and position if you fail your first attempt at upgrade...especially from a Jet FO to Prop CA position.
I also don't believe a single training failure should EVER cost you your job, from #1 to a probie doing his/her initial check.