The Approved Termination Request Is Still In Pending Status (Root Of The Error Investigation and Transaction Console) (Doc ID 2533490.1)

Last updated on AUGUST 25, 2023

Applies to:

Symptoms

On : 11.13.19.01.0 version, Global Payroll

When attempting to terminate employee, the approved termination request is still in Pending status.

ERROR
-----------------------
BusinessFault : {http://xmlns.oracle.com/apps/hcm/employment/core/transactionApprovalService/}ServiceException. Client received SOAP Fault from server : JBO-29000: Unexpected exception caught: oracle.jbo.JboException, msg=JBO-29000: Unexpected exception caught: oracle.apps.fnd.applcore.messages.ApplcoreException, msg=JBO-FND:::FND_GENERIC_MESSAGE: The message is ORA-20001: The employment level entered is not eligible for the element Gratuity Processing on 2019-03-31. Details: You cannot grant the element to the payroll relationship, terms or assignment unless it meets the element eligibility criteria and has an element costing record. Ensure that a suitable element costing rule exists for the element, and that the eligibility criteria for a person matches those defined on the costing rule. ORA-06512: at "FUSION.PAY_ELEMENT_ENTRY_API", line 468 ORA-06512: at line 53 .JBO-29000: Unexpected exception caught: oracle.apps.fnd.applcore.messages.ApplcoreException, msg=JBO-FND:::FND_GENERIC_MESSAGE: The message is ORA-20001: The employment level entered is not eligible for the element Gratuity Processing on 2019-03-31. Details: You cannot grant the element to the payroll relationship, terms or assignment unless it meets the element eligibility criteria and has an element costing record. Ensure that a suitable element costing rule exists for the element, and that the eligibility criteria for a person matches those defined on the costing rule. ORA-06512: at "FUSION.PAY_ELEMENT_ENTRY_API", line 468 ORA-06512: at line 53 .JBO-FND:::FND_GENERIC_MESSAGE: The message is ORA-20001: The employment level entered is not eligible for the element Gratuity Processing on 2019-03-31. Details: You cannot grant the element to the payroll relationship, terms or assignment unless it meets the element eligibility criteria and has an element costing record. Ensure that a suitable element costing rule exists for the element, and that the eligibility criteria for a person matches those defined on the costing rule. ORA-06512: at "FUSION.PAY_ELEMENT_ENTRY_API", line 468 ORA-06512: at line 53 .

EXPECTED BEHAVIOR
--------------------------------------
Approved Termination Request being in Completed Status.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Initiate Employee Termination;
2. The Approved Termination Request is Still in Pending Status;
3. The Transaction can not be found under Transaction Console only by SQL querying.

SQL Results Details:
TXN_STATUS PENDING
MODULE_IDENTIFIER Terminations
PERSON_NUMBER 1234
CREATION_DATE 2019-04-02 07:36:25
TRANSACTION_ID 300000007654321
CREATED_BY user.x@company.com
COMPOSITEINSTANCEID 30121
TITLE Termination for X, 1234 (2019-03-31)

Cause

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