My Oracle Support Banner

NZ Payroll - Error Processing Annual Leave Termination Extra Pay (Doc ID 2439645.1)

Last updated on JUNE 18, 2019

Applies to:

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

Symptoms

On : 12.1.3 version R12.HR_PF.B.Delta.10, New Zealand Payroll

When attempting to run Payroll after adding the element 'Annual Leave Termination Extra Pay' for a terminated employee, the following error occurs.

HR_6867_HRPROC_FMLA_ORA_ERR
ORACLE_ERROR_TEXT
FORMULA_ERROR_TEXT Data PAY_NZ_GET_EFF_DATE not found at line 238 of NZ_ANNUAL_L
EAVE_TERMINATION_PAYMENT

Cause: A SQL SELECT statement, obtained from the application dictionary,
returned no rows when executed.

Action: Please refer to your loc
APP-PAY-06867: An error occurred during formula execution:

Data PAY_NZ_GET_EFF_DATE not found at line 238 of NZ_ANNUAL_LEAVE_TERMINATION_PAYMENT

Cause: A SQL SELECT statement, obtained from the application dictionary, returned no rows when executed.

Action: Please refer to your loc



STEPS
The issue can be reproduced at will with the following steps:

1. Terminate an Employee
2. Add the element 'Annual Leave Termination Extra Pay'
3. Run Payroll

Cause

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
Symptoms
Cause
Solution
References


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