OTBI showing home department instead of worked/cost department for reported hours

We’ve noticed a reporting discrepancy between HCM and OTBI when it comes to department allocation for hours worked.

In HCM, an employee’s hours are correctly charged to the department where the work was actually performed (let’s call it “Worked Department”).

However, when we run an OTBI report using the worker’s department field, those same hours show under the employee’s home department (the department on their profile) instead of the worked/cost department.

It appears that OTBI is defaulting to the home department rather than the department associated with the actual hours worked.

Question: Is there a way in OTBI to pull the