The following table lists the default Oracle ERP account attributes. All attributes are optional.
Resource User Attribute |
Data Type |
Description |
---|---|---|
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. |