REASON_CODE is not populating in PER_ALL_ASSIGNMENTS_M table

We have custom reports which are using the REASON_CODE column from PER_ALL_ASSIGNMENT_M table. After we enabled Redwood, the REASON_CODE column stopped populating

UI shows the action reason is "Personal Reasons"

Tried to run below query and as you can see the REASON_CODE is showing as Null for PER_ALL_ASSIGNMENTS table

SELECT
ACTION_CODE
, REASON_CODE
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
FROM
PER_ALL_ASSIGNMENTS_M
WHERE
ACTION_CODE = 'TERMINATION'
AND ASSIGNMENT_TYPE IN ('E', 'C')
L
AND PERSON_ID = <PERSON_ID>
ORDER BY
EFFECTIVE_START_DATE DESC

Output:

Any idea on this?