Resolved! Cancelling a HR case via UI does not make case inactive, even state changes to Cancelled
The requirement is cancelling the hr_case should inactive the record like Close Complete or Close Incomplete. I tried a few below options and watched the field, even it showed these have made the field from true -> false, but it had not actually set ...
