The following two tables list, respectively, the attributes that may be provisioned from Oracle Directory Services to Oracle E-Business Suite, and from Oracle E-Business Suite to Oracle Directory Services.
Note: This is a subset of the attributes listed in the provisioning templates.
Attributes Provisioned from Oracle Directory Services to Oracle E-Business Suite
| Oracle Directory Services Attribute name | FND_USER Column Name | TCA Table and Column Names |
|---|---|---|
| UID and [nickname]* | USER_NAME | |
| DESCRIPTION | DESCRIPTION | |
| FACSIMILETELEPHONENUMBER | FAX | |
| EMAIL_ADDRESS | HZ_CONTACT_POINTS.EMAIL_ADDRESS (CONTACT_POINT_TYPE is 'EMAIL') | |
| SN | HZ_PARTIES.PERSON_LAST_NAME | |
| TELEPHONENUMBER | HZ_CONTACT_POINTS.RAW_PHONE_NUMBER (CONTACT_POINT_TYPE is 'PHONE' and CONTACT_POINT_PURPOSE is 'BUSINESS' | |
| STREET | HZ_LOCATIONS. ADDRESS1 | |
| POSTALCODE | HZ_LOCATIONS.POSTAL_CODE | |
| PHYSICALDELIVERYOFFICENAME | HZ_PARTY_SITES.MAILSTOP | |
| ST | HZ_LOCATIONS.STATE | |
| L | HZ_LOCATIONS.CITY | |
| GIVENNAME | HZ_PARTIES.PERSON_FIRST_NAME | |
| HOMEPHONE | HZ_CONTACT_POINTS.PHONE_NUMBER (CONTACT_POINT_TYPE is 'PHONE' and CONTACT_POINT_PURPOSE is 'PERSONAL') | |
| C | HZ_LOCATIONS.COUNTRY |
* Refer to Recommended Nickname (Login Attribute) Setting for more information.
Attributes Provisioned from Oracle E-Business Suite to Oracle Directory Services
| FND_USER | Oracle Directory Services |
|---|---|
| USER_NAME | UID and [nickname]* |
| DESCRIPTION | DESCRIPTION |
| EMAIL_ADDRESS | |
| FAX | FACSIMILETELEPHONENUMBER |
| END_DATE | ORCLACTIVEENDDATE |
| START_DATE | ORCLACTIVESTARTDATE |
| START_DATE/END_DATE | ORCLISENABLED |
| ENCRYPTED_USER_PASSWORD | USERPASSWORD |
* Refer to Recommended Nickname (Login Attribute) Setting for more information. Also refer to Configuring Directory Integration Platform Provisioning Templates for details of the provisioning process.