+7Hello All,
I’m trying to migrate users between environments and I’m missing data.
Why can’t I migrate the email address?
If so, what do I add to the migration job.
The field seems to be part of the same table, but does not get added to the migration job.
Thanks,
Rob
Best answer by Jens
Hi
I suppose you already use the fnd_user db-view to export and import the users.
To get the email_address of a user please have a look into the db-view fnd_user_property (filter for name = ‘SMTP_MAIL_ADDRESS’).
Identity = user_id
name = SMTP_MAIL_ADDRESS
VALUE = email address
/Jens
+5Can you provide the screenshot of your migration job and the email field ?
+10Hi
I suppose you already use the fnd_user db-view to export and import the users.
To get the email_address of a user please have a look into the db-view fnd_user_property (filter for name = ‘SMTP_MAIL_ADDRESS’).
Identity = user_id
name = SMTP_MAIL_ADDRESS
VALUE = email address
/Jens
+7I was building migrations jobs, but if there is a better way, can you please point me in the right direction?
+7
+7
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.