| Print Open PDF Version of Online Help

#### UserValue The UserValue function in Expression Builder returns the value of a specified attribute for the current user. The fields on the User Detail view are attributes of the selected user. ### Syntax UserValue('<attribute>') ### Result Type String ### Arguments The following table describes the arguments for the function.
Argument | Description
--- | ---
attribute | The language-independent name or customized integration tag that corresponds to the display name of the current user attribute. Integration tags are displayed in the Integration Tag Web Services v2.0 column in the record type Fields page.
### Examples Example1: A business process requires that a custom text field called Origin on a service request is to display by default the country of the user who creates the record (the current user) when the record is created. To implement the business rule, in the Field Setup page for service requests, set the default value for the Origin field to UserValue('<PersonalCountry>'), and select the Post Default check box. For information about creating and editing fields, see Creating and Editing Fields. Example 2: A business process requires that a certain workflow rule is triggered if the owner of an opportunity is not the administrator. To implement the business rule, set up the following condition on the workflow rule: UserValue('<EMailAddr>') <> 'administrator@testdata.com' ### Attributes The following table lists the attributes that can be used as arguments in the UserValue function, and their corresponding display names.
Attribute | Display Name | Sample Value
--- | --- | ---
Alias | Alias | Admin
AuthenticationType | Authentication Type | User ID/Password Only
BusinessUnit | Business Unit | Business Unit
BusinessUnitLevel1 | Business Unit Level 1 | Business Unit L1
BusinessUnitLevel2 | Business Unit Level 2 | Business Unit L2
BusinessUnitLevel3 | Business Unit Level 3 | Business Unit L3
BusinessUnitLevel4 | Business Unit Level 4 | Business Unit L4
CellPhone | Cellular Phone # | +1 555 2368978
CreatedBy | Created By | Oracle CRM On Demand CSR Admin
CreatedById | Not available | 1E1263-IZBZ
CreatedDate | Created Date | 01/08/2007 21:21:33
CurrencyCode | Currency | USD
Department | Department | Department
Division | Division | Division
EMailAddr | Email | john.doe@oracle.com
EmployeeNumber | Employee Number | 12345
EnableTeamContactsSync | Enable Sync of Team Contacts | Y
ExternalIdentifierForSingleSignOn | External Identifier for Single Sign-On | UID=ADMIN,O=ORACLE
ExternalSystemId | External Unique ID | EXTUID123
FirstName | First Name | John
FundApprovalLimit | Fund Approval Limit | 50000
IntegrationId | Integration ID | INTUID123
JobTitle | JobTitle | Product Manager
Language | Language | English-American
LastLoggedIn | Last Sign In | 10/31/2007 19:39:01
LastName | Last Name | Doe
LeadLimit | Lead Limit | 2345679
Locale | Locale | English - Canada
ManagerFullName | Reports To | John Smith
ManagerId | Not available | 1E4763-IZAU
Market | Market | Market
MiddleName | Middle Name | Middle
MiscellaneousNumber1 | Miscellaneous Number 1 | 2312
MiscellaneousNumber2 | Miscellaneous Number 2 | 2312
MiscellaneousText1 | Miscellaneous Text 1 | DUNS # (Webcat) = 10461
MiscellaneousText2 | Miscellaneous Text 2 | a7cff064-6566-47a2-8629-8b32d92de222
ModifiedBy | Modified By | John Doe
ModifiedById | Not available | 1E1263-IZBZ
ModifiedDate | Modified Date | 10/31/2007 19:32:58
MrMrs | Mr./Ms. | Mr.
NeverCall | Never Call | Y
NevereMail | Never Email | Y
NeverMail | Never Mail | Y
PasswordState | Password State | Active
PersonalCity | City | Toronto
PersonalCountry | Country | Canada
PersonalPostalCode | Postal Code | M4C2C3
PersonalProvince | Province | Ontario
PersonalState | State/Province | CA
PersonalStreetAddress | Street | 555 Main Avenue
PersonalStreetAddress2 | Address 2 | Suite 17
PersonalStreetAddress3 | Address 3 | Scarborough
PhoneNumber | Work Phone # | +1 555 2365555
PrimaryDivisionName | Primary Division | Asia Division
PrimaryGroup | Primary Group | User Group A
PrimaryPvgName | Not available NOTE: The PrimaryPvgName attribute returns the name of the picklist value group that is associated with the user's primary division. | India PVG
Region | Region | My Region
Role | Role | Field Sales Rep
RoleId | Role Id | 1E1263-IYG1
SecondaryEmail | Secondary Email | john.doe2@oracle.com
ShowWelcomePage | Show Welcome Page on Sign In | N
Status | Status | Active
SubMarket | Submarket | My submarket
SubRegion | Subregion | My sub region
TempPasswordFlag | Email Temporary Password When I Click Save | Y
TimeZoneName | Time Zone | (GMT-05:00) Eastern Standard Time (US & Canada)
UserId | Row Id | 1E1263-IZAU
UserLoginId | Row Id | 1E1263-IZAU
UserSignInId | User Sign In ID | PTE169-14/ADMIN
WorkFax | Work Fax # | +1 555 2365556
#### Related Topics See the following topics for related Expression Builder information: About Expression Builder Using Expression Builder Expression Builder Functions

Published 5/23/2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.