Fusion Absence Management: "ANC_PER_ABS_ENTRIES" and "ANC_PER_ABS_PLAN_ENTRIES" tables are not in SYNC
(Doc ID 1981486.1)
Last updated on FEBRUARY 01, 2019
Applies to:Oracle Fusion Application Toolkit - Version 126.96.36.199.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 188.8.131.52.0 and later
Oracle Fusion Absence Management Cloud Service - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
We have created a report for getting Annual Leave Balance of the employees. We are facing an issue after the recent upgrade of the environment. When we ran the report yesterday morning we were able to view the data for only 50 employees but by the previous night we were able to view the data for around 150 employees in the report run. But we are able to view the absences for all the employees at the UI. When we checked the back end tables we find that data is present for all the employees in "ANC_PER_ABS_ENTRIES" table but the data is not present in the "ANC_PER_ABS_PLAN_ENTRIES" table. So, we are able to view the data at the UI but report is not fetching the same data as we have used ANC_PER_ABS_PLAN_ENTRIES table in our Data Model. So, Could you please explain if it is data load issue due to recent upgrade or some other issue.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document