Incorrect manufacturing lead time

Summary:

The lead time rollup is not calculating correct variable lead time for the item

Content (please ensure you mask any confidential information):

The lead time rollup is not calculating correct variable lead time for the item. It's a simple WD with just 1 OP and 1 resource but still Oracle is going wrong.

Resource usage: 0.05 hrs

Plant Calendar Shift: 2 shifts in calendar: 06 AM -4 PM and 4PM to 2AM.

Resource assigned to 1 of the shift: 4PM to 2AM.

Lot size: 1

Oracle calculation logic for variable lead time:

Variable lead time : (usage of the variable resource divided by the total shift duration)/lot size.