PAY_AU_ASG_LEAVE_TAKEN_V Returning Overlapping Leave

(Doc ID 1925636.1)

Last updated on JULY 14, 2016

Applies to:

Oracle HRMS (Australia) - Version 12.1.1 and later
Information in this document applies to any platform.


PAY_AU_ASG_LEAVE_TAKEN_V is returning overlapping leave.
We have an employee in the system with Annual Leave
19-DEC-2013 ==> 03-JAN-2014

PAY_AU_ASG_LEAVE_TAKEN_V is returning 2 records
(1) 19-DEC-2013 ==> 03-JAN-2014
(2) 01-JAN-2014 ==> 03-JAN-2014.

Note that we have also ran seeded program "Pay Advice (Australia)" and the same results are happening.
ie ... the output is showing 2 Overlapping Annual Leaves

All Payroll Run figures and Leave Accrual are not affected.
Issue appears only to be happening for this 1 employee (at this stage)

Leave Taken
Annual Leave 19-DEC-2013 - 03-JAN-2014
Annual Leave  01-JAN-2014 - 03-JAN-2014

Expecting the view and report to only return 1 annual leave record.


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