Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Sickness Absence End Date not updated in ANC_PER_ABS_TYPE_ENTRIES table

Received Response
11
Views
2
Comments

We initially have had an existing approved Sickness Absence for an employee with duration -

Start Date - 01/06/2025

End Date - 28/06/2025

Then we have modified the End Date and updated the End Date to - "Open Ended" absence.

Now the End Date has been updated in ANC_PER_ABS_ENTRIES table, but it's not getting updated in ANC_PER_ABS_TYPE_ENTRIES table.

We have run the "Evaluate Absence" process with all the 4 modes but no luck.

Can anyone advise ?

Screenshot 2025-06-27 112832.jpg Screenshot 2025-06-27 113107.jpg

A.END_DATE is from ANC_PER_ABS_TYPE_ENTRIES - End Date not updated, still showing old End Date

B.END_DATE is from ANC_PER_ABS_ENTRIES - End Date updated to NULL

Answers

  • Hi,

    As your question is about Fusion data, it isn't really a Publisher (technical) question.

    Fusion, its data, its embedded reporting, is covered in a parallel (but independent) forum: https://community.oracle.com/customerconnect

    You will find lot of categories there, including some about analytics and reporting. Have a look and find the best place where to ask your data question.

  • Raktim_Pal-IBM
    Raktim_Pal-IBM Rank 2 - Community Beginner

    Thanks.

    I have already raised there: https://community.oracle.com/customerconnect/discussion/comment/1395621#Comment_1395621