owner

string 

The administrator who created the account. 

start_date

string 

The date the account is effective. 

end_date

string 

The date the account expires. 

Set the date to a previous date to disable an account. 

Specify a null value to indicate no expiration date.

Use the sysdate or SYSDATE keyword with end-date to specify an expiration date for a user with the local time of the Oracle EBS server.

description

string 

A description of the user, such as the full name. 

password_date

string 

The datestamp of the last password change. 

The Oracle ERP adapter can use this datestamp when evaluating the password_lifespan_days attribute value. For example if you set the password_lifespan_days attribute to 90, then Oracle ERP will calculate 90 days out from the last password change date (password_date) to determine if the password is expired. 

Each time the Oracle ERP adapter performs a password change, it will set the password_date to the current date. 

password_accesses_left

string 

The number of times the user can use the current password. 

password_lifespan_accesses

string 

The number of accesses over the life of the password 

password_lifespan_days

string 

The total number of days the password is valid. 

employee_id

string 

Identifier of employee to whom the application username is assigned. 

employee_number

string 

Represents an employee_number from the per_people_f table.

When you enter a value on create, the adapter tries to look up a user record in the per_people_f table, retrieve the person_id into the create API, and insert the person_id into the fnd_user table’s employee_id column.

If no employee_number is entered on create, no linking is attempted. 

If you enter an employee_number on create and that number is not found, then the adapter throws an exception. 

The adapter will try to return the employee_number on a getUser, if employee_number is in the adapter schema.

person_fullname

string 

The full name of the user. 

npw_number

string 

Contingent worker number. It represents an npw_number from the per_people_f table.

When you enter a value on create, the adapter tries to lookup a user record in the per_people_f table, retrieve the person_id into the create API, and insert the person_id into the fnd_user table’s employee_id column.

If no npw_number is entered on create, no linking is attempted.

If you enter an npw_number on create and that number is not found, then the adapter throws an exception.

The adapter will try to return the npw_number on a getUser, if npw_number is in the adapter schema.

Note: The employee_number attribute and npw_number attribute are mutually exclusive. If both are entered on create, employee_number takes precedence.

email_address

string 

The e-mail address of the user. 

fax

string 

The fax number of the user. 

customer_id

string 

The customer ID of the user. 

supplier_id

string 

The supplier ID of the user. 

responsibilities

string 

The names of the responsibilities assigned to the user. Valid for Oracle EBS 11.5.9 only. 

Use the sysdate or SYSDATE keyword with to_date to specify an expiration date for a responsibility with the local time of the Oracle EBS server.

responsibilityKeys

string 

The keys associated with the user’s list of responsibilities. 

securingAttrs

string 

Adds supports for securing attributes. 

expirePassword

boolean 

Indicates whether the password will be expired. 

directResponsibilities

string 

Returns the user’s direct responsibilities. Valid for 11.5.10 only. 

indirectResponsibilities

string 

Returns the user’s indirect responsibilities. Valid for 11.5.10 only. 

auditorResps

List of a user’s Active Responsibilities. 

formIds

Concatenates all Form IDs. Includes values returned by readOnlyFormIds and readWriteOnlyFormIds. 

formNames

Concatenates all Form Names. Includes values returned by readOnlyFormNames and readWriteOnlyFormNames/ 

functionIds

Concatenates all Function IDs 

functionNames

Concatenates all Function Names 

menuIds

Concatenates all Menu IDs 

readOnlyFormIds

Concatenates all Read-Only Forms IDs 

readOnlyFormNames

Concatenates all Read-Only Form Names 

readOnlyFunctionNames

Concatenates all Read-Only Function Names 

readOnlyUserFormNames

Concatenates all Read-Only User Form Names 

readWriteOnlyFormIds

Concatenates all Read/Write-Only Forms Ids 

readWriteOnlyFormNames

Concatenates all Read/Write-Only Form Names 

readWriteOnlyFunctionNames

Concatenates all Read/Write-Only Function Names 

readWriteOnlyUserFormNames

Concatenates all Read/Write-Only User Form Names 

userFormNames

Concatenates all User Form Names. Includes values returned by readOnlyUserFormNames and readWriteOnlyUserFormNames/ 

userFunctionNames

Concatenates all User Function Names 

userMenuNames

Concatenates all User Menu Names.