Life Event not Triggering from Data Pump Upload
Last updated on AUGUST 01, 2017
Applies to:Oracle Advanced Benefits - Version 12.1 HRMS RUP5 and later
Information in this document applies to any platform.
Employee data imported via Data Pump process does not trigger the New Hire life event as expected. Only life events associated with the assignment table are triggering; Work Location Change and Salary Changed.
When importing data from a comma delimited file that was previously exported from a recruitment system, loading the data pump tables using data pump API’s; hr_pump_utils, hrdpp_create_employee, hrdpp_create_person_extra_info, hrdpp_create_person_address, hrdpp_update_emp_asg_criteria, hrdpp_update_emp_asg, hrdpp_create_element_entry, and hrdpp_upload_salary_proposal are the packages used to load the data into the data pump tables, and submitting via the seeded Data Pump process.
LIFE EVENT TRIGGER
- Table Name: PER_PERSON_TYPE_USAGES_F
- Column Name: PERSON_TYPE_ID
- Old Value: Any Value
- New Value: Employee
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Load data from a comma delimited file previously exported from a recruitment system to the following data pump APIs:
2. Submit the Data Pump Engine process for the batch.
- New Hire/Rehire life event is not detected
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms