In a small bowl, dissolve raspberry gelatin in boiling water. Whisk in cranberry sauce until blended. Transfer to a 13-in. x 9-in. dish coated with cooking spray. Refrigerate until set but not firm, about 45 minutes.
For the cream layer, in a small saucepan, sprinkle gelatin over cold water. Let stand for 1 minute. Heat over low heat, stirring until gelatin is completely dissolved. Cool to room temperature.
In a small bowl, combine sour cream and vanilla. Fold in gelatin mixture, then whipped topping. Spoon over cranberry layer and gently spread. Refrigerate until set but not firm, about 45 minutes.
Drain oranges, reserving 1 cup syrup; set oranges aside. In a small bowl, dissolve orange gelatin in boiling water. Sir in reserved syrup. Refrigerate until slightly thickened, about 45 minutes. Stir in oranges. Carefully spoon over sour cream layer. Cover and refrigerate for 8 hours or overnight.