My Oracle Support Banner

Fusion Global HR: How to join dates between ANC_PER_ABS_ENTRIES and FUSION.HR_DOCUMENTS_OF_RECORD (Doc ID 2609829.1)

Last updated on SEPTEMBER 24, 2020

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version and later
Information in this document applies to any platform.


To prepare a report joining dates from ANC_PER_ABS_ENTRIES to get a leave start date, leave end date, leave status and also from HR_DOCUMENTS_OF_RECORD to get the rejoining date for employee leave and request details, the below queries can be used:


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.