Gonna +1 this. Heavy oil and light oil are both intermediate products that can't be used directly, so I think this is definitely a bug that production modules can't be used.
EDIT: I just found the solution. One needs to modify the Production Module prototype to add the condensation recipes to the limitation property:
https://lua-api.factorio.com/latest/prototypes/ModulePrototype.html#limitation