Skip to main content

I am looking to extract the email addresses from user accounts in sqldeveloper but do not know the location of the field.

Using version 10
It is showing on the create User screen  but system info shows only as 
Control: textboxEmail
Whats this ID: labelEmail.

Any help appreciated

 

 

Hi @pknight 

 

SELECT IDENTITY, VALUE FROM fnd_user_property
WHERE NAME='SMTP_MAIL_ADDRESS'

 

IDENTITY is the Identity field

VALUE is the Email address

 

/Jens

Thanks Jens for the prompt reply

 

Works perfectly

Is there a way to update this using SQL. the table space is read only

 

Why not using the procedure FND_USER_PROPERTY_API.Modify__ instead of using hard updates on the table for this purpose?

 

The best way is to use the “Data Migration” tool in IFS Applications 10 (search for Migration Job in the navigator).

Procedure name = MIGRATE_SOURCE_DATA

Source_name = FND_USER_PROPERTY (you can also add a WHERE clause in this screen)

Tab Method list: View Name = FND_USER_PROPERTY (Method Name FND_USER_PROPERTY_API will be automatically filled)

/Jens

Reply


Terms & ConditionsCookie settings