I'm shamelessly stealing this from solo roleplayer Kate Korsaro. In a blog post, she writes that the four compass points of adventure are Danger, Opportunity, Success, and Failure, and she gives the following ingenious tables for oracular use:
DANGER
-------
| d6 | Category | Source | Magnitude or Distance |
|----:|-----------|--------------|-------------------------|
| 1 | Trap | Architecture | Distant or Trivial |
| 2 | Ambush | Mechanisms | Minor or Peripheral |
| 3 | Hazard | Creatures | Approaching or Moderate |
| 4 | Puzzle | Magic | Nearby or Noticeable |
| 5 | Curse | Inhabitants | Concerning or Imminent |
| 6 | Intrusion | Nature | Immediate or Pressing |
OPPORTUNITY
| d6 | Category | Source | Magnitude or Distance |
|----:|------------|-------------|------------------------|
| 1 | Offer | Nature | Minor or Hidden |
| 2 | Discovery | People | Curious or Distant |
| 3 | Request | Wildlife | Helpful or Peripheral |
| 4 | Opening | Ruins | Notable or Wandering |
| 5 | Revelation | Folklore | Significant or Nearby |
| 6 | Contest | Minor Magic | Fortunate or Immediate |
SUCCESSES
| d6 | Reason | Boon | Consequence |
|----:|------------------|------------|-----------------|
| 1 | Proper Technique | Efficiency | Speed |
| 2 | Experience | Precision | Durability |
| 3 | Ideal Conditions | Insight | Advantage |
| 4 | Keen Focus | Resilience | Recognition |
| 5 | Ingenuity | Momentum | Resourcefulness |
| 6 | Assistance | Mastery | Opportunity |
FAILURES
| d6 | Reason | Mishap | Consequence |
|----:|---------------------|----------|-------------|
| 1 | Inappropriate Tools | Harm | Damage |
| 2 | Lack of Skill | Breakage | Delay |
| 3 | Poor Conditions | Loss | Setback |
| 4 | Distraction | Exposure | Noise |
| 5 | Misjudgment | Waste | Confusion |
| 6 | Fatigue | Misfire | Cost |