Oracle HRMS – E-Mail Address or any particular field needs to be Changed For All Employees


You can use our public API to update Email address (hr_person_api ) use procedure (update_person)
Note: take care when you pass Object_version_number parameter
As per these people are existing employees so you have to get the latest Object_version_number by
running this Select statement.

Here’s the piece of code which demonstrates how to call the API:

l_employee_number per_people_f.employee_number%TYPE;
l_person_id per_people_f.person_id%TYPE := 373;
l_per_object_version_number per_people_f.object_version_number%TYPE;
v_effective_start_date date;
v_effective_end_date date;
v_full_name varchar2(100);
v_comment_id number;
v_name_combination_warning boolean;
v_assign_payroll_warning boolean;
v_orig_hire_warning boolean;
Select object_version_number ,employee_number
into l_per_object_version_number ,l_employee_number
from per_people_f
where person_id = l_person_id ;
p_validate => FALSE
,p_effective_date => to_date(’29-JAN-2006′,’DD-MON-YYYY’)
,p_datetrack_update_mode => ‘CORRECTION’
,p_person_id => l_person_id
,p_object_version_number => l_per_object_version_number
,p_employee_number => l_employee_number
,p_email_address => ‘’
,p_effective_start_date => v_effective_start_date
,p_effective_end_date => v_effective_end_date
,p_full_name => v_full_name
,p_comment_id => v_comment_id
,p_name_combination_warning => v_name_combination_warning
,p_assign_payroll_warning => v_assign_payroll_warning
,p_orig_hire_warning => v_orig_hire_warning

Alternatively, you can Use ADI by creating an integrator that use this API, that i will give more explanation in article for “Building ADI for HRMS”

Oracle HRMS- Employee Directory Video Demo

Dear Friends,

 Here is a sample video from our Oracle HRMS Training program. 

The Oracle Apps HRMS Training DVD is a set of 3 DVDs with hours of Oracle Training videos. The Training DVD covers modules HR (core), Payroll, Benefits, introduction to OAB, OLM, OTL, iRec etc. Its a technofunctional training on Oracle Apps HCM modules. Each chapter starts with a functional background, process requirements and data flow, business understanding of the concepts, and then deals with Oracle setups, technical details, table structure etc.

If you think this video makes sense and it helped you learn something, you can give yourself a chance to learn the whole Oracle HRMS suite of applications in just few days. If you are interested, you can buy the training DVD online at

Please let us know you views about this program and if you have any questions, send them to , or here: or comment on this post here. Thank you.

Also, We are planning to start a 7 days training program soon with the following topics: Core HRMS Implementation, Module Study: Payroll, SSHR, Benefits & OAB; Introduction of iRecruitment, CWB, OLM and OTL. If you are interested in this 7 days training, the fee for US based students will be 50$ per hour for individual courses, or 999$ for the full 7d*3hr program.