User

The user object allows you to define and record details of all users in Oracle CRM On Demand, for example, name, position, contact details, manager, and so on. It enables queries to be run on all users, and enables an administrator to insert and update a user’s profile.

Usage

The UserLoginId and UserSignInId fields must be used as follows:

UserLoginId. Used for creating user records through the User Web service.
UserSignInId. Used as the user name for logging in and authenticating using Web services. Also, used for queries, as using UserLoginId is not allowed for queries.

Starting with Oracle CRM On Demand Release 23, you can use the DefaultBookId and DefaultAnalyticsBookId fields respectively to access the default book and default analytics book for a user. In previous releases it was possible to access the default books through the DefaultBookName and DefaultAnalyticsBookName fields only.

A user can be associated with one or more divisions. You can associate users with divisions in two ways:

From a division record, through the user child object
From a user record, through the division child object

The first division that is associated with a user record is automatically specified as the primary division for the user, but you can change the primary division for the user through the PrimaryDivisionName field.

Child Objects

Assigned Books, Audit Trail, Delegated User, Division, User Default Book Per Type

Methods Called

The following table details the methods called by the User service.

Table Methods Called by User Service

Method	Name as Defined in Service
Execute	UserExecute
Insert	UserInsert
QueryPage	UserQueryPage
Update	UserUpdate

Fields

The following table details the required and read-only fields for the user object.

Table Required and Read-Only Fields for the User Object

Field Name	Type
FirstName	Required
LastName	Required
UserLoginId	Required
UserSignInId	Required
Alias	Required
EmailAddr	Required
Role	Required
Status	Required
Audit Fields	Read-only
LastSignInDateTime	Read-only
ManagerFullName	Read-only

The following table details the pick map field for the user object.

Table Pick Map Field for the User Object

Pick Map Field	Maps To
Role	RoleId

The following table provides a list of user key combinations for the user object.

Table User Key Fields on the User Object

User Key Field Combinations
Id
UserId
ExternalSystemId
Alias