Human Capital Management - EBS (MOSC)

MOSC Banner

Need help in - Best approach to send email to 100 users reminding them to update SSN of thier depend

edited Dec 11, 2011 10:35PM in Human Capital Management - EBS (MOSC) 8 commentsAnswered ✓
Hi All,

We have a requirement where we have to send remider to all employees , to update the SSN of their newly born child . This is a monthly process .

There will be no data send out to employees just a text message to remind them ..

I have thought of few ways to do it , but if there is any better way please suggest..

1) Create a Pl/sql program to identify all such employees who haven't update SSN for thier child and then kick off a workflow to send notification within the program

2) Create a program which will run seprately for each employee and then a shell script which  send the output of program as an attachment to each employee

Tagged:

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