When does Sora get the Ultimate recipe

Depends on which game. If it's the first one, you need to synthesize everything else in order to get the Ultima Weapon. If it's in the second one, you need to go to Twilight Town and enter the room with the pods. It's in a chest.