I've seen a bunch of reports where showmood suggested things were alright when the game made quite clear they weren't. Unsurprisingly, this just shows that showmood isn't perfect, it's not a sign of a problem in the game.
Showmood and the game-internal requirement lists show that the full list of desired items is determined the moment a mood strikes. Most material requirements are fairly unspecific - any stone, any wood, any bone, any rough gem, any cut gem, any block etc. For those materials, anything that fits the basic class is acceptable, a dwarf won't refuse working with oak wood because they've a preference for some other wood type.
A few materials are naturally specific: cloth is always demanded as one of the three 'base' types plant, wool, silk; it's not unusual to only have one type of cloth of a class available, but cloth is easily acquired through trade. Glass, when required, must always be a 'rough gem' type piece of glass and i think it always specifically asks for one of the three glass types green/clear/crystal, nothing else will do. They can only ask for glass you've actually created in your fort (i think that means you must have made an item of this glass type at a glass furnace).
I'm aware of two preference-determined material requests:
- a dwarf with preference for a specific type of metal who enters a metalworking mood will require the preferred type of metal as base material, if you've ever produced bars of this metal in your fort. Dwarfs in such a mood will not substitute any other metal, and if it's a fey mood, they will spell out their specific requirement.
- a dwarf with preference for any type of 'shell' who enters a bonecarving mood will require shells of any kind as base material. They won't ask for the specific preferred shell type, but will demand shells even if you've never had a shell in your fort.
Adamantine is a material all dwarfs love, so metalworkers and clothiers/weavers will always claim adamantine wafers or cloth as base material for moods if any are available.