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) */
DECLARE
   l_extra_info_id   NUMBER;
   l_obj_num         NUMBER;
BEGIN
   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);

   hr_assignment_extra_info_api.delete_assignment_extra_info
                               (p_assignment_extra_info_id      => l_extra_info_id,
                                p_object_version_number         => l_obj_num
                               );
END;

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Archives
Categories
History Under Your Feet

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

Habib's Oracle World

My Oracle Experiences

appstechnotes

Oracle Apps Technical Notes

David Haimes Oracle Intercompany Financials Blog

The fascinating world of Intercompany (No really!) and Oracle Financials

Oracle Scratchpad

Just another Oracle weblog

The Daily Post

The Art and Craft of Blogging

WordPress.com News

The latest news on WordPress.com and the WordPress community.

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: