Home » Applications » Oracle Fusion Apps & E-Business Suite » Mass User creation automation in ebs (EBS 11.5.10)
Mass User creation automation in ebs [message #578002] Fri, 22 February 2013 10:27
Messages: 1
Registered: February 2013
Junior Member
Hi All

We have a scenario

we are handling Non Production servers where we need to create lot of users daily.

So the thing is after refreshing the Prod fix environment from Production we are end dating all the produciton users and we are creating the new users through sql script using FND create package where we have two scripts one for creating the user and 2nd for adding the responsibilites corresponding to the user in other script which are ran as a part of post refresh scripts.

So below are the few steps we are doing

1) login to server
2) pbrun
3) then going to the specific location where those two files are placed
4) taking the backup of those two files
5) then adding the new user creation script at the end of the file
6) Adding the name of the user in the non end dated command
7) Adding the responsibilites assinging commands to the second file

Now I want the following things

1) Need to create a unix script which when i will run first login to database using apps and asks for the number of usernames to be created newly
2) To check if those users exist already if yes then asking for other name
3) Creating the users at runtime and adding the same in the file after taking the current backup.
4) Asking for the list of responsibilities (can be provided in a flat file)
5) Need to add those responsibilities once at that time and adding the script to the second file after taking its backup.

Can you please assist in this

[EDITED by LF: removed garbage from topic title]

[Updated on: Sat, 23 February 2013 10:56] by Moderator

Report message to a moderator

Previous Topic: Screen or Report that shows all Responsibilities for Org Unit
Next Topic: India Localization
Goto Forum:

Current Time: Fri Mar 31 01:54:41 CDT 2023