Absence Adjustment value in the database doesn't match the front-end

Question

I am using the Workforce Management - Accrual Real Time subject area, from which I am retrieving the "Front-Loaded Plan - Other Adjustments" field.

The report is displaying adjustment values for some employees, even though no adjustment value is currently available for them in the front end. These values appear to be related to adjustments that were previously added and then removed, but they are still being returned in the report.

Could you please help investigate why these removed adjustments are still appearing and how to exclude them from the report results?

Bhaskar Konar · Answer

Hi @Youstina Nasr,

Welcome to the Oracle Analytics & AI Community!

One thing worth checking is whether the 'Calculate Accruals and Balances' process has run successfully since the adjustment was removed. If the accrual balances haven't been recalculated after the change, OTBI may continue to report outdated values.

If the process has already completed successfully and the report still returns adjustment values that are no longer visible in the application, I'd recommend contacting Oracle Support.

Hope this help.

Thank you.