My Oracle Support Banner

US Federal PAR Processing - When Terminating an Employee Last Date Worked is Set Incorrectly. (Doc ID 1560534.1)

Last updated on FEBRUARY 06, 2019

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.


Termination of employee sets the last date worked equal to the Termination Date, no error message is generated. Termination 01/01/2008, last date worked set to 01/01/2008. User can save this without any Component Interface (CI) errors, however if a retroactive row is inserted between the Termination row and the row previous to the termination, and tries to save, then the Component Interface errors are generated and the save changes does not complete.

Steps to Replicate
1. Federal database sign in HFG/HFG
2. Navigate to Workforce Administration > Job Data > HR Processing USF
3. Select an employee (e.g. emplid LE0004), Terminate the employee and save, the save completes
4. In the HR Processing USF component go to Employment Data 2 page, Click on the Non Pay Data link, note the Last Date worked is the same as the termination date, and also note that during the save no errors were generated.
5. Using the same employee, in correct history mode, insert a retro dated row between the termination row and the previous row, using a different effective date once the date is completed on the page then save. The user will receive a message saying that the Reviewed check box on the data control page needs be checked before trying to save. During the save a Component Interface error is generated relating to the Termination Date and the Last Date Worked being the same and therefore the changes are not saved.

Error message:

Last Date Worked cannot be equal or greater than the Effective Date of the Action Changing the Status (1000,1101)
Error Changing Value CI_JOB_DATA.COLL_JOB(2) PROP_LAST_DATE_WORKED (91,34)




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

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