Friday 6 July 2007

Fndload command for migrating fnd_users from one instance to another

Fndload command for migrating fnd_users from one instance to another

How to migrate users from one instance to another instance using FNDLOAD utility, steps to be run pre and post the clone process.

Download
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct /tmp/userlist.ldt FND_USER USER_NAME="RAF"

Upload

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct /tmp/userlist.ldt

If same user is not present in another instance then FNDLOAD will not migrate same password instead
user password will be changed to 'welcome'.
If same user is present in another instance then FNDLOAD will migrate same password.

No comments:

Profile - Oracle 11i AppsDBA
Over 7 years of experience as an Oracle Applications DBA managing Oracle Public Sector HRMS 11.5.10 and Oracle Financials 11i in Unix and Windows NT environments. Strong skills and experience with installing, patching, cloning and troubleshooting various Oracle E-Business Suite products in Oracle database 9i and 10g. Proactive in the different phases of architecture design, development, testing, maintenance, performance enhancement and postproduction support. Currently working as Oracle Application DBA at Warwickshire County Council.

------------------------------------------------------------------------------------------------------------------------------