Unable to view Hired candidate details in Redwood requisition

Summary:

One of our customers has enabled Redwood ORC for the job requisition page. Now when they click the Hires hyperlink when the number is not zero, because there is a Hire and the candidate has been moved to HR successfully, the next page doesn't return any results in PROD where you would expect to see the list of inactive candidates pending HR processing. The page loads but there are no results presented.

The issue is only happening in PROD. TEST has the same configuration but is working correctly

Content (please ensure you mask any confidential information):

The requisition shows that there should be one candidate who has been hired and should be able to be accessed via the link.