<-----Google Analytics Code Start----> <-----Google Analytics Code Close---->
Skip to content



Default screen resolution  Wide screen resolution  Increase font size  Decrease font size  Default font size  Skip to content Default color Pink color Green color Green color
Home arrow Technical Articles arrow Oracle Scripts arrow SSHR Rollout Create FND_USER and Allocate Responsibilities
This website has now moved to http://apps2fusion.com

SSHR Rollout Create FND_USER and Allocate Responsibilities | Print |  E-mail
Written by Anil Passi   
Sunday, 10 December 2006
Every organization that rolls out any Oracle Self Service Application requires a methodology to allocate responsibilities and to create Users.

The pseudo code example taken here has following requirements:-
1. Create a concurrent program, passing to parameter for one Cost Centre/Group or all Cost Centres.
This way, Self Service can be rolled out in Phased manner.
2. Besides a parameter for the cost centre, there will be another parameter to run the process in a Read-Only mode.
3. There are two possibilities for the Employees which are eligible(given their cost centre).
    Possibility a. The employee already has an existing FND_USER record
    Possibility b. The employee does not have an existing FND_USER record.

Solution for Possibility a.
    Identify the FND_USER record, using the fnd_user.employee_id  = per_all_people_f.person_id
    Use fnd_user_resp_groups_api.insert_assignment to add new Self Service responsibility to that User.
    Send the user an Email giving them details of the responsibility that has been added.

Solution for Possibility b.
    Create an FND_USER record, using the fnd_user_pkg, attaching this to Person Id.
    Use fnd_user_resp_groups_api.insert_assignment to add new Self Service responsibility to that User.
    Send them an email to inform the User-Id and Password along with instructions to log on & use the application.

Questions & Answers
How do I create a 8 digit password for FND_USER record?
FUNCTION get_random_password RETURN VARCHAR2 IS
         RETURN lower(dbms_random.STRING('X',8));
END get_random_password;

We  want users to be enforced to alter their password every 6months, how to ?
Use parameter x_password_lifespan_days
    x_user_name => p_user_name
   ,x_owner => ''
   ,x_unencrypted_password => v_password
   ,x_description => p_person_description
   ,x_password_lifespan_days => 180
   ,x_employee_id => p_person_id
   ,x_email_address => p_email_address

The random password that is generated might have repeating characters, which will error if Profile "Signon Password Hard To Guess" is Set to Yes?
You can temporarily set the profile to N in the session during which concurrent program runs.
fnd_profile.put(NAME => 'SIGNON_PASSWORD_HARD_TO_GUESS' ,val => 'N');

Should I use Workflow to inform users?
You might as well use SMTP. Be careful  that on Dev environment  business  users do not receive Emails.
This can be ensured by checking return of select instance_name from v$instance  to be PRD Database.
You can use procedure send_html_email in the Code Sample in link provided in the article.

Can I run the source code as is?
The source code provided is for allocating a responsibility named "XX HR Employee Self Service".I have removed all the  client specific bits from the code. Hence you will need to alter to make this to be of any use. The idea is to merely provide you a guideline for API Usage.

Link for script to create temp audit table and views

Package Header for Script

Main  code with  Package  Body Link to the script

Comments (5)add
missing tablea
written by Nakhla , October 11, 2007
Dear Sir

I tried to run create fnd user script but i got the follwing

PL/SQL: Declaration ignored
PLS-00201: identifier 'XX_COLL_DIR_PULL' must be declared

IC_COLL_DIR_PULL is table missing from tables creation script

kindly advise


written by Anil Passi , October 11, 2007
You need to remove reference to that, I forgot to remove that reference from the script

Anil Passi
written by Nakhla , October 11, 2007
Dear Sir,

can you send me structure for this table

about sshr & payroll
written by muniraj , November 16, 2007
hi anil
am having adoubt in PTO in payroll,plz help me regarding this

written by Med , November 25, 2007
Dear sir,

I need structure of table xx_windows_logon_table.

You must be logged in to a comment. Please register if you do not have an account yet.