Definitely, they use information from DS-5535 to send queries to different departments , FBI, CBP, EOIR,DOS, ....more updates, more waiting time,until all feedback.
It seems that your case just pending in MTL consulate level, quite predictable I guess,not involved external DS-5535 long wait processing..............
It should be I-797 approval action notice.
As you applied the second petition to USCIS, due to only one IV case allowed, so the Consulate will cancel your DS-260 and return the case to USCIS. Fiy
It is hardly to say the success rate, but at least WOM has somehow impact to remedy the process I think. If you have capacity: money to hire lawyer or writing skill to file WOM online at local E-court system by yourself , with sound gounds , to convince judge stand by you.
It is not strange that if you met a junior VO / CO , he / she wont take a very little risk then escalate the case to DS-5535 pool at DC headquarters. According to US government manual guide, VO/CO issues visa at own judgement if applicant without any hardcore issues. Why consulate in Mexico has few DS-5535 / AP cases , every month more than 2000 IV visas issued ? You will have an answer in mind ?
Congratulations first!!
For reason over the hump, I am prone to believing that WOM working rather than security check cleared. Nowdays big data time,DS-5535 clears in 1 hour ,as 4 or 5+ times updates shown on CEAC status tracker after it was submitted.
As to SAO, security advisoy opinion is just a reference, CO/VO has his/her own decision.
it will show expiring date, such as Jan,xx,2025. DS-260 valid for 2 years , After that date , need to do apply pettetion from bottom again, ie.submit application to USCIS, my uderstanding
you could monitor the MTL web page to estimate time frame :
https://ca.usembassy.gov/embassy-consulates/consular-operations-updates/
As of Feb 15,2024, they touched the cases of Nov, 2023, 3 months ago. for high piority IR1 class
Also, IV application DS-260 valid for 2 years , can find the expiring date from NVC login. Whereas NIV,can apply again after denied to avoid some tough Consulates.