Sunday, 30 October 2022

Create User Similar to Other User in Oracle EBS

 


Assumption : Create User Prodadmin with similar rights of Devadmin

STEP 1: 

Use FNDLOAD to download user definition from source instance:

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

STEP 2:

 Modify the ldt file - Change the line to

BEGIN FND_USER "prodadmin"
OWNER = "APPSMGR"
LAST_UPDATE_DATE = "2022/10/20”
START_DATE = "2022/10/30"

STEP 3: 

Use FNDLOAD to upload new user to target instance:

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

STEP 4: 

Change the password of the new user from application front end,email and other details as required.



No comments:

Post a Comment