EBS Customizations (MOSC)

MOSC Banner

Firing a Trigger Whenever an Employee is terminated

edited Oct 16, 2012 8:58PM in EBS Customizations (MOSC) 2 commentsAnswered
 Dear All

I am writing a trigger which needs to be fired whenever an employee is terminated in Oracle HRMS E-Bussiness Suite. There is a custom table which will save some data in columns of that particular employee. Problem is that an Exception is being thrown when employee is terminated. I have tried using AFTER UPDATE ON PER_ALL_PEOPLE_F and AFTER UPDATE ON PER_ALL_ASSIGNMENTS_F. I dont want to touch standard tables. I want only how my trigger get fired whenever an employee is terminated.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center