Schema Reference
The application schema is used to configure the objects returned from a connector.
Note
-
The Account Schema tab is used to define the attributes for each object type in the application being configured. The schema attributes can be defined as Entitlement or Multi-Valued. Refer to Managing Source Account Schemas for more information.
-
The schema attributes that are not present by default must be defined as strings if not specified.
The Oracle E-Business Suite connector uses the following default correlation and object configurations.
Default Account Schema
Each source supports a variety of details, or attributes, about each user who has an account, such as their name, email address, manager name, and location.
The set of account attributes each source stores and how they're organized is known as the account's schema. To best represent your data, you can configure sources to use an account schema matching the one you use in the external connector. Refer to Managing Source Account Schemas for more information.
Default Account ID
SailPoint requires that certain attributes remain in your configuration. These attributes are referred to as account IDs.
Caution
Changing the attribute marked as the account ID after aggregating accounts can result in duplicate accounts being created. To avoid this, either reset the accounts on this source before editing the account ID attribute or edit the account ID attribute before aggregating accounts.
To resolve issues caused by changing account IDs, reconfigure them to their default values.
The following table lists the default account IDs for this connector:
| Account ID | Schema Object Type |
|---|---|
| USER_NAME | Account |
| RESPONSIBILITY_ID | Responsibility GroupObjectType |
| NAME | Role GroupObjectType |
| MENU_ID | Menu GroupObjectType |
Default Account Attributes
The Oracle E-Business Suite connector supports the following default account schema attributes and customer configurable attributes. The attributes must be defined as strings if not specified.
| Attribute Name | Description |
|---|---|
| USER_NAME | Application username (what a user types in at the Oracle Applications sign-on screen). This is an Account ID which must not be changed. |
| USER_ID | The application user identifier. |
| START_DATE | The date the user name becomes active. |
| END_DATE | The date the user name becomes inactive. |
| DESCRIPTION | The description. |
| PASSWORD_DATE | The date the current password was set. |
| PASSWORD_EXPR | The number of accesses left for the password. |
| PASSWORD_NO_OF_DAYS | The number of accesses allowed for the password. |
| EMAIL_ADDRESS | The electronic mail address for the user. |
| FAX | The fax number for the user. |
| EMPLOYEE_ID | The identifier of the employee to whom the application username is assigned. |
| EMPLOYEE_NUMBER | The unique number of the employee. |
| FULL_NAME | The full name of the user. |
| CUSTOMER_ID | The customer contact identifier. If the AOL user is a customer contact, this value is a foreign key to the corresponding customer contact. |
| CUSTOMER_NAME | The customer name. |
| RESPONSIBILITIES | The responsibilities assigned to a user. |
| ROLES | The roles assigned to a user. |
Default Entitlement Attributes
Entitlement attributes define the entitlements, such as groups or roles, that can be assigned to the managed system's user accounts. Refer to Managing Entitlements for more information.
Caution
Changing the attribute marked as the Entitlement ID after aggregating accounts or entitlements can result in duplicate entitlements being created, or access profiles and roles breaking. To avoid this, edit the entitlement schema before performing any aggregations.
Default Group Attributes
The Oracle E-Business Suite connector also supports groups. The following attributes must be configured on the managed system and in the SailPoint source schema to manage groups.
| Attribute Name | Description |
|---|---|
| RESPONSIBILITY_NAME | The name of the responsibility. |
| APPLICATION_NAME | The application that owns the information for the responsibility. |
| RESPONSIBILITY_ID | The responsibility identifier. This is an Account ID which must not be changed. |
| RESPONSIBILITY_KEY | The internal developer name for responsibility. |
| START_DATE | The date the responsibility becomes active. |
| END_DATE | The date the responsibility expires. |
| DESCRIPTION | The description |
| STATUS | Shows the status of the responsibility. |
| VERSION | The version. |
| WEB_HOST_NAME | The IP address or alias of the computer where the Webserver is running. Defaults to the last agent. |
| WEB_AGENT_NAME | The name of Oracle Web Agent. Defaults to the last agent. |
| DATA_GROUP_APPL_NAME | The name of the data group application. |
| REQUEST_GROUP_APPL_NAME | The request group application name. |
| DATA_GROUP_ID | The identifier of the data group. |
| DATA_GROUP_NAME | The name of the Data Group. |
| MENU_NAME | The name of the menu. |
| REQUEST_GROUP_NAME | The request group name. |
Documentation Feedback
Feedback is provided as an informational resource only and does not form part of SailPoint’s official product documentation. SailPoint does not warrant or make any guarantees about the feedback (including without limitation as to its accuracy, relevance, or reliability). All feedback is subject to the terms set forth at https://developer.sailpoint.com/discuss/tos.