Solved

Migrating Users in Cloud environments

Userlevel 2

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

icon

Best answer by Jens 9 February 2024, 18:31

Userlevel 1

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

Userlevel 4

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

Userlevel 2

@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?

Userlevel 2

Userlevel 2

Sign up