# 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](<https://documentation.sailpoint.com/saas/help/accounts/schema.html>) for more information.
> - The schema attributes that are not present by [default](<#default-account-schema>) must be defined as strings if not specified.

The Oracle ERP Cloud 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](<https://documentation.sailpoint.com/saas/help/accounts/schema.html>) 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 |
| --- | --- |
| ID | Account |
| ID | Group |

### Default Account Attributes

The Oracle ERP Cloud 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 |
| --- | --- |
| ID | A unique identifier for the user resource in Oracle Applications Cloud. This is an Account ID which must not be changed. |
| Display Name | The display name of the user, usually the full name. |
| Email | The primary email address of the user. |
| User Name | A unique identifier for the user to authenticate with the service provider directly. |
| Status | Indicates the administrative status of the user. |
| First Name | The first name of the user. |
| Last Name | The last name of the user. |
| Last Modified Date | The last modified date of the user. |
| Created Date | The created date of the user. |
| User Category | The user category of the user. Default: `DEFAULT` |
| Account Type | The account type of a user to indicate the person or party association. |
| Manager | The manager associated to the user. |
| Person Number | The worker ID or person number associated to the user. |
| Business Unit | The business unit to which the user belongs. |
| Department | The department to which the user belongs. |
| Job | The job title of the user. |
| Roles | The list of roles assigned to the user. |
| Data Access | Combination of role, security context, and its values assigned to the user. |

### Additional Account Attributes

The Oracle ERP Cloud connector supports aggregation of additional account attributes which are part of SCIM API. The attribute name must be the same as the API response JSON path.

> [!NOTE]
>
> The `__c` suffix must be added for additional schema attributes. Ensure that you append `__c` at the end of the attribute name. For example, if you want to add the `preferredLanguage` attribute, you must add `preferredLanguage__c`. For more information, refer to [Adding Attributes to a Source Schema](<https://documentation.sailpoint.com/saas/help/accounts/schema.html#editing-an-account-schema>).

The following attributes are supported:

- `preferredLanguage__c`
- `schemas__c`
- `meta__c`
- `urn:scim:schemas:extension:fa:2.0:faUser__c`

## 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](<https://documentation.sailpoint.com/saas/help/access/entitlements.html>) 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 ERP Cloud 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 |
| --- | --- |
| ID | A unique identifier for the role resource in Oracle Applications Cloud. This is an Account ID which must not be changed. |
| Description | The description of the role. |
| Category | The category of role. |
| Name | A unique identifier for the role to authenticate with the service provider directly. |
| Last Modified Date | The last modified date of the role. |
| Created Date | The created date of the role. |
| Display Name | The display name of the role. |