Oracle HRMS – Create Employee API

This blog describes the process and technical information required for creating new employee using API.

In any business organization employee should there to do the work, so Oracle provide hr_employee_api.create_employee API to create new employee with other important information as per the requirement.

hr_employee_api.create_employee

      (                                    

       p_hire_date                      => TO_DATE ('14-SEP-2015'),

       p_business_group_id=>fnd_profile.value_specific('PER_BUSINESS_GROUP_ID')

       p_last_name                      => ' SUMEDH ',

       p_first_name                     => ' AYAR ',

       p_middle_names                   => NULL,

       p_sex                            => 'M',

       p_national_identifier            => '163-19-6789',

       p_date_of_birth                  => TO_DATE ('03-DEC-1992'),

       p_known_as                       => ' SUMEDH ',

       p_employee_number                => lc_employee_number,

       p_person_id                      => ln_person_id,

       p_assignment_id                  => ln_assignment_id,

       p_per_object_version_number      => ln_object_ver_number,

       p_asg_object_version_number      => ln_asg_ovn,

       p_per_effective_start_date       => ld_per_effective_start_date,

       p_per_effective_end_date         => ld_per_effective_end_date,

       p_full_name                      => lc_full_name,

       p_per_comment_id                 => ln_per_comment_id,

       p_assignment_sequence            => ln_assignment_sequence,

       p_assignment_number              => lc_assignment_number,

       p_name_combination_warning       => lb_name_combination_warning,

       p_assign_payroll_warning         => lb_assign_payroll_warning,

       p_orig_hire_warning              => lb_orig_hire_warning

      ); 

  

--Pradipta Behera