Solved

Table name for field

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

icon

Best answer by Jens 14 December 2022, 13:48

Userlevel 4

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

Userlevel 4

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

Sign up