For people asking whats the hidden requirement for too horny to sleep in the barracks. You need to visit apothecary and have the event where soldier is asking for meds. Offer to bring them to barracks and he tells you to leave it with quartermaster. when you do that, instead of meds, give him lust potion. I have also done quest where quartermaster asked you for tea and you had option to add few extra lust potions, not sure if both are needed for the event
(It was event about spying on 2 soldiers fcking so not sure if thats the one in the update)