Do not know about that. Summer eventually advanced to the final career level, she was able to make the concoction, and the opportunities stopped at level 10. Up to that point, she got the opportunities at Level 9 & 10, of Mixology skill.
I do want to say, since it doesn't seem to be clear in the guides, is when you get the opportunity, it will either be fake, and your Sim will be angry for a few hours, or the Sim will get a message to the effect, that there's something in the book, that they can use. There's no real message, indicating any mythic miracle. Also, the recipe will appear, with no fanfare, once the Sim has reached level 10. Now, maybe if the opportunity is missed, and the Sim is in the final career tier, it might continue to appear, until the Sim gets the book. I don't know. Maybe, it didn't reappear, because I already had the ability.
If you put the drink in the fridge of a friend Sim, then play that Sim, the drink should be available for him/her to drink. Often things in the fridge that are there when you stop playing a Sim, will also be there when you resume playing.