# UK Court Order AEO Not Deducting After Termination When Act Term Date Is < End Of Period

(Doc ID 2013988.1)

Last updated on JULY 11, 2016

## Applies to:

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

## Symptoms

Find that when an employee is terminated MID PERIOD, court orders are not deducted when there is a payment after leaving (and they should be).

Within the Court Order formula the very first section is:

v_first_day = greatest(v_emp_hire_date, PAY_PROC_PERIOD_START_DATE)
v_last_day = least(v_processing_end_date,EMP_TERM_DATE)
v_actual_days = days_between(v_last_day, v_first_day) + 1
IF v_actual_days < 0 THEN
( v_deduction = 0
v_info_msg = TYPE + ': no deduction taken'
RETURN v_deduction,
v_info_msg
)

I have the following scenarios:

1. Employee leaves on 23-JUN-14 (mid period), in July they receive a payment after leaving.

The Court Order NTPP element is processed and the following message is received "AOE no deduction taken". Based on the above section of formula this is correct as v_actual_days = -7 + 1 = -6.

2. Employee leaves on 31-JUL-14 (end of period), in August they recieve payments after leaving.

The Court Order NTPP element is processed and the expected deduction is made. Based on the above section of the formula this is correct as v_actual_days = -1 + 1 = 0.

-- Expected Behaviour
When an employee is terminated and there is a payment after leaving, but before the Final process date, the Court order should be deducted if there are sufficient earnings.

-- What is working
When the ACTUAL TERMINATION DATE is on the last date of the payroll period, and there is a payment after leaving, the Court Order amount is deducted as expected.

-- Steps
The issue can be reproduced at will with the following steps.
1. Give employee an AEO type Court order and run payrolls as normal.
2. Terminate employee with the following dates :
ATD : 15-APR-2015
LSP : 30-MAY-2015
FPD : 30-JUN-2015

3. Run Quickpay for April - all deducted ok

4 - Run Quickpay for May - with a payment after leaving - CO is NOT deducted

HOWEVER -

Terminate employee with the following dates :
ATD : 30-APR-2015
LSP : 30-MAY-2015
FPD : 30-JUN-2015

Run quickpay for May - and the CO IS deducted.