My Oracle Support Banner

Incorrect/Wrong Action Code Visible On UI After Loading Worker (Doc ID 2108982.1)

Last updated on FEBRUARY 04, 2019

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version and later
Information in this document applies to any platform.


After loading employees through HDL using "Worker.dat" file, it is seen that "Manage Employment" UI shows Assignment action as 'Hire', even though the latest row sent on the file is for 'Termination'.

However, checking 'History' for the Assignment shows the correct action for the latest row (Resignation).

Post Load Processes "Update Person Search Keywords" and "Synchronize Person Records" have been run.

Checked the Person with the issue:
  select * from per_all_assignments_m where person_id = (select person_id from per_all_people_f where person_number = '<person number>')
  Latest Assignment Row (ASSIGNMENT_TYPE = 'E') has ACTION_CODE of 'RESIGNATION' - Correct
  Latest Work Terms Row (ASSIGNMENT_TYPE = 'ET') has ACTION_CODE of 'HIRE' - Incorrect

It is expected that the "Manage Employment" UI should also show the correct status (Resignation).
  However, this shows 'Hire' which Could be from the Work Terms row which shows as 'Hire' - However, the file has the WT row's action as 'RESIGNATION' (same as the Assignment Row) so this shouldn't have happened.

The issue can be reproduced at will with the following steps:
1. Load Worker using HDL (ensuring rows go to Success for the employee) with latest Assignment row as "RESIGNATION"
2. Run "Update Person Search Keywords" and "Synchronize Person Records" processes
3. Navigator -> Person Management -> Search for the employee -> click on "Manage Employment" -> Under "Assignment Details", check the value next to the 'Action' field - this shows as "Hire" - THIS IS INCORRECT
4. Navigator -> Person Management -> Search for the employee -> click on "Manage Employment" -> Click on the "History" button for the Assignment, check the value under the 'Action' column - this shows as "Resignation" - THIS IS CORRECT


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.