I posted this on AA forum - it got 141 views but only 2 posts. Neither of the 2 were particularly helpfull in addressing my question (they were of some help).
So I am trying here in hope of getting some good advice:

Clearly I am newbie to this forum, but not to travel in general. I fly for pleasure only (I am retired) and save up my miles through various means (CC, buy miles, promotions, etc) in order to upgrade to J for long haul flights. I have been very successful over the years but it’s always an adventure.
I have been recently exploring FT forum and have learned a lot (long ways to go yet, I am sure). I could not locate a thread that addresses this specific issue (or I just probably cannot find it). One of the pointers I did pick up in my search is to use ExpertFlyer to find award U seats.
I gave it a try but it was a total failure.
I was looking for U seats from SFO to SIN in a one week window 322 to 329 days out. I understand that Expertflyer cannot show CX, JL or other OW awards seats (it shows only AA U seats) but it did not show even seats that were available on code share with JL (as confirmed with an AA agent.) Nor did it show 9W flight via PVG, which I believe is also a code share, and was available.
What am I missing? Is there a better way or a better site to locate award U seats on OW partners before calling AA?
Please help.