One of my players decided to be a Lore Oracle and can't quite decide what Lore she wants from her mystery. I thought it would be a great idea to let me choose it based on something that'll show up later in the campaign as foreshadowing of some kind.
Similar to the Haunting Vision background in Age of Ashes.
I'm thinking of something related to the King of Biting Ants and in that style, possibly Insect Lore? Do you have any other good ideas?
Probably any of the Lore skills mentioned in the players guide (Academia Lore Magaambya Lore, Nantambu Lore, Mzali Lore, Insect Lore, Jungle/Forest Lore).
As for other ideas, Folktale Lore could grant them insight into what's going on around them, and you could even quote the stories and lore from the books. Maybe they'll know stories about how Jatambe once fought an evil sorcerer, and banished him from Golarion?
Speaking of Jatambe, Jatambe Lore could be useful. It kind of overlaps with Magaambya Lore, but I think it's distinct enough to fulfill a different role.
Maybe Osibu Lore. The character could have grown up hearing legends of the hidden city, and perhaps they somehow tapped into the powers/mind of the great Dimari-Diji.
As said above, the Player’s Guides for 2e APs have so far been pretty good at suggesting what Lores and Languages players might need.