How To Create A New User From Existing User With Same Responsibilities in R12 :

FNDLOAD can be used to achieve this task. SYSADMIN is used for example purposes only. Steps below can be used for any Application user you have defined. For the example below the new user SVRADMIN will be created.

To Find the RESPONSIBILITY on particular "USER" to use bellow query :
SQL> set pages 1500
SQL> set linesize 400
SQL> set lines 400

spool Usr_resp.csv

SELECT frt.RESPONSIBILITY_NAME, furg.end_date

FROM

fnd_user_resp_groups furg,

FND_RESPONSIBILITY fr,fnd_responsibility_tl frt,fnd_user fu

WHERE fu.user_name = '&&username'

AND   fu.user_id = furg.user_id

AND   furg.responsibility_id = fr.RESPONSIBILITY_ID

AND   frt.responsibility_id = fr.RESPONSIBILITY_ID

ORDER BY 1;

SQL> spool off;

1. Use FNDLOAD to download user SYSADMIN from your instance:

FNDLOAD apps/<apps password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct  SYSDMIN.ldt FND_USER USER_NAME=SYSADMIN

2. Modify the ldt file (SYSADMIN.ldt for the example above).  Change the line <BEGIN FND_USER "SYSADMIN"> to <BEGIN FND_USER "SVRADMIN">

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct  SVR_DMIN.ldt FND_USER USER_NAME=SYSADMIN

3. Use FNDLOAD to upload new user to your instance:

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct  SVR_ADMIN.ldt  FND_USER   USER_NAME=SVRADMIN

Note : Doc ID 1474294.1

+++++++++++++++++++++++++++++++++++++

Missing SYSADMIN Responsibility After Upgrade To 12.1.3 (Doc ID 1246824.1)

++++++++++++++++++++++++++++++++++++++

SOLUTION

Please run the below concurrent programs in the order given, with the respective values of the parameters, and then retest the issue.

1. Workflow Directory services user/role validation with argument values as 10000:Yes:Yes:No:NULL.

2. Synchronize WF Local Tables with default values for the arguments.

3. Run adadmin - Compile/generate menu and rebuild JAR files.

4. Rerun:  FNDLOAD APPS/<apps_password> 0 Y UPLOAD @FND:patch/115/import/afscursp.lct @FND:patch/115/import/US/wfssresp.ldt

++++++++++++++++++++++++++

Can FNDLOAD Migrate User Accounts Without Forcing Users To Change Their Passwords? (Doc ID 376469.1)

 Here is the syntax used:

Create datafile (download):

FNDLOAD apps/<passwd> 0 Y DOWNLOAD  $FND_TOP/patch/115/import/afscursp.lct  $FND_TOP/patch/115/import/userlist.ldt FND_USER USER_NAME='TEST'

Upload to target system:

FNDLOAD apps/<passwd> 0 Y UPLOAD  $FND_TOP/patch/115/import/afscursp.lct  $FND_TOP/patch/115/import/userlist.ldt FND_USER

+++++++++++++++++
http://docs.oracle.com/cd/E18727_01/doc.121/e12843/T156458T156460.htm

745920.1

743719.1

Understanding HRMS Seed Data (Doc ID 422525.1)

Note 140511.1 How to Install Legislative Data Using Data Installer and hrglobal.drv

Note 145837.1 Latest HRMS (HR Global) Legislative Data Patch Available