Fusion Apps: OTBI, Annual Leave Details For Few Employees Are Not Getting Fetched
Last updated on MAY 04, 2018
Applies to:Oracle Fusion Application Toolkit - Version 18.104.22.168.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 22.214.171.124.0 and later
Oracle Fusion Absence Management Cloud Service - Version 126.96.36.199.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms