Skip to main content

Hello 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

Can you provide the screenshot of your migration job and the email field ?


Hi @rfedorchuk 

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


@Jens , I’m trying to find an easy way to migrate users into production.

I was building migrations jobs, but if there is a better way, can you please point me in the right direction?


 


 


Reply