Fusion Payroll : System Not Calculating Gratuity Payment For The Termination After Global Transfer (Doc ID 2058146.1)

Last updated on MARCH 11, 2025

Applies to:

Symptoms

On : 11.1.8.0.0 version, Manage Payroll

When attempting to run Quick Pay after employee termination the following error occurs.

ERROR
-----------------------
Error was encountered when processing payroll relationship 10769-1
An error occurred when processing element {ELEM_NAME, (ETNAME=GRATUITY)
An error occurred when processing formula AE_GRATUITY_PROCESSING.
An error occurred during formula execution, Contact your helpdesk (ORACLE_ERROR_TEXT=) (FORMULA_ERROR_TEXT=Formula XXX_GET_ASSIGNMENT_STATUS, line 13, too many rows returned.)
Formula GET_ASSIGNMENT_STATUS, line 13, too many rows returned.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Hired employee with Hire Date : 1-Jan-2002
2. Nationality selected, Mapped salary and Payroll relationship during Hiring.
3. Enrolled with a absence plan and processed accrual for 2 months to add absence deduction card
4. Processed Quick pay for the month of Jan 2014 and verified results
5. Updated Employment with action: Global Transfer on 1-Feb-2014. Changed service date
6. End of service Details mapped to the employee with 31-Jan-2014 date.
7. Ran Quick pay again for Jan 2014. No Gratuity Payment Processed.
8. Created Employee calculation card for the new legal employer.
9. Auto indirect card mapped twice with different effective from date
10. Gratuity Accrual Calculate for the month of Feb 2014
11. Terminating employee from new Legal Employed on 31/3/2014
12. End of Service Details attached to the employee on the termination date
13. Error in Quick Pay after Termination

Cause

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