Giving oral sex to a vagina is very low risk. There is a slight chance of getting oral gonorrhea, chlamydia, and syphilis, but the chances are really low.
Receiving oral sex is a risk for gonorrhea, chlamydia, syphilis, and genital herpes type 1 (if your friend doesn't already have oral herpes type 1).
There is no risk for HIV.
Your friend can test for gonorrhea and chlamydia at 5 days (oral needs an oral swab, and he should ask for that specifically), and syphilis at 6 weeks. Syphilis is uncommon in most developed countries. If he's in the US, the UK, Canada, most European countries, etc., I wouldn't worry much about this.
Your friend can get a test for herpes type 1 with a type specific IgG blood test at 12 weeks, but unless he gets sores, I wouldn't bother. The test misses 30% of infections, hsv1 is incredibly common and he might have it orally already - 67% of people under 50 globally do - so if he gets sores, he can go to the doctor and get those tested within 24-48 hrs.
Herpes sores usually appear within 2-12 days. A syphilis sore usually appears between 10-90 days, but the average is 3 weeks.
Don't get freaked out about all this - the chances are really low. I'm just giving you info. Most experts don't think a single act of oral sex requires testing.