Check the Extended Productivity in the Leave Requester's User record.

If they zero total, then a Timesheet will not be created.