Oracle HRMS: Cannot delete an employee – Assignment Extra Information Exists

Issue: User cannot delete an employee record on HRMS People Enter and Maintain screen as there are assignment extra information exists for the employee.

Solution: Use API to delete assignment extra information for the employee.

/* Formatted on 2014/04/23 09:50 (Formatter Plus v4.8.8) */
   l_extra_info_id   NUMBER;
   l_obj_num         NUMBER;
   SELECT assignment_extra_info_id, object_version_number
     INTO l_extra_info_id, l_obj_num
     FROM per_assignment_extra_info
    WHERE assignment_id = (SELECT DISTINCT assignment_id
                                      FROM per_all_assignments_f
                                     WHERE assignment_number = &p_asg_num);

                               (p_assignment_extra_info_id      => l_extra_info_id,
                                p_object_version_number         => l_obj_num

Go to HRMS Manager > People > Enter and Maintain

Query the employee record and delete it.

Tagged with: , , , , , , ,
Posted in HRMS and Payroll, Oracle, scripts

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

HCM Cloud Hub

History Under Your Feet

The past is there, right where you stand, under your feet.

Habib's Oracle World

My Oracle Experiences


Oracle Apps Technical Notes

David Haimes Oracle Apps and Cloud ERP Blog

My thoughts and updates on all things Oracle Applications

Oracle Scratchpad

Just another Oracle weblog

The Daily Post

The Art and Craft of Blogging

The Blog

The latest news on and the WordPress community.

%d bloggers like this: