My Oracle Support Banner

Payroll Run Error with DataBase item: ENTRY_END_DATE in Custom Formula After Appling 30017585 (Doc ID 2738698.1)

Last updated on JULY 03, 2023

Applies to:

Oracle Payroll - Version 12.1 HRMS RUP11 and later
Information in this document applies to any platform.

Symptoms


ACTUAL BEHAVIOR
----------------------------
Observed that, there are incorrect salary amount if payroll group is changed in mid of month as below sample cases after appling <Patch 30017585>(which is included in 12.1 RUP13 or 12.2 RUP14)

Scenario 1: In Payroll Run, It is showing “Employee has terminated” when Payroll has been updated.

Scenario 2: Salary is not able to calculate in Payroll Run when there is a change of Payroll



EXPECTED BEHAVIOR
-----------------------------
Expect that, there should be correct salary amount even as above sample cases



Steps to Reproduce:
The issue can be reproduced at will with the following steps:

Scenario 1: In Payroll Run, It is showing “Employee has terminated” when Payroll has been updated.

1.Apply <Patch 30017585>

2. Login application and select the responsibility your HRMS Manager

3. Navigate to People > Enter and Maintain > (B) Assignment

4. Change the payroll with effective date "01-DEC-2020"

5. Navigate to Report and Processes and Submit Report and Processes

6. Run payroll and then check the message and it says the following

"E Annual Salary: Employee has terminated"

or in case of Scenario 2, no salary has been processed on steps5.


OR


When attempting to run Retropay or Payroll Run,
the following error occurs in Assignment Process Results - Message form.

Error was encountered when processing Element Type MIL GENERAL ALLOWANCE
Error was encountered when processing formula MIL_GENERAL_ALLOWANCE
An error occurred during formula execution

NULL value for ENTRY_END_DATE at line 99 of MIL GENERAL ALLOWANCE
Cause: A SQL SELECT statement, obtained from the application dictionary, returned a column whose value was NULL.


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

1. Using HRMS Manager responsibility.

2. Navigate to Processes and Reports > Submit Processes and Reports.

3. Run Retropay or Payroll Run.

4. Navigate to View > Assignment Process Results > Message.

5. Observe the error.

Changes

 

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
Changes
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.