Thursday, October 22, 2009

API to Purge an person from Oracle HRMS

DECLARE
   l_person_org_manager_warning VARCHAR2 (200);
BEGIN
   hr_person_api.delete_person(p_validate => FALSE,
                               p_effective_date => SYSDATE,
                               p_person_id => :person_id,
                               p_perform_predel_validation => FALSE,
                               p_person_org_manager_warning => l_person_org_manager_warning
                              );
   COMMIT;
END;

Before purging the person from Oracle HRMS we need to make sure that the employee and fnd_user link is been deleted and also the person should not have an active payroll.
If the employee has an active payroll then we cannot purge the record. The alternative way is to either end date the employee using the termination screen or you need to change the person from 'Employee' to 'Applicant' and then use the above API again to purge the record.

Thanks & Regards,
Anto Joe Natesh

1 comment:

  1. These provided information was really so nice,thanks for giving that post and the more skills to develop after refer that post. Your articles really impressed for me,because of all information so nice.
    HRMS Software In India
    HRMS Software Chennai
    HR Software In Chennai
    HR Management Software In India

    ReplyDelete