To add Extra Information Types (EITs) to an organization classification: To add Extra Information Types (EITs) to an organization classification:Define a new organization classification. You do not need to do this if you are setting up an EIT for a classification that already exists.
Note: To define a new classification, enter a new value for the Lookup type ORG_CLASS in the Lookup Values window.
Define the new EIT. See: Entering Table Values
Unprotect the Org Developer DF using the Register Descriptive Flexfield window. You must do this before you can query the flexfield on the Descriptive Flexfield window
Add the new structure for the EIT to the Org Developer DF descriptive flexfield using the Descriptive Flexfield Segments window. The structure must have as its context the name of the extra information type, and as this is a context sensitive descriptive flexfield you must enter C_ORG_INFORMATION_CONTEXT in the Reference Field. Compile in the same way as a standard descriptive flexfield.
Reset the protection, so the flexfield remains a protected descriptive flexfield.
You need to enter rows into the following tables:
HR_ORG_INFORMATION_TYPES
HR_ORG_INFORMATION_TYPES_TL
Oracle recommends that you write a script to carry out the HR_ORG_INFORMATION_TYPES_PKG.INSERT_ROW procedure to create the rows in the base table and translation table. The procedure uses the following parameters:
| Parameter | Column name | Description |
|---|---|---|
| X_ORG_INFORMATION_TYPE | ORG_INFORMATION | Name of the type (same as DDF context). |
| X_DESCRIPTION | DESCRIPTION | Description of the extra information type. |
| X_DISPLAYED_ORG_INFORMATION_TP | DISPLAYED_ORG_INFORMATION_TYPE | The Name of the Extra Information Type displayed in the Organization window. |
| X_NAVIGATION_METHOD | NAVIGATION_METHOD | "GS" for single row, a user can only enter one extra information row for each organization. Alternatively, "GM" for multi row, a user can enter more than one row for each organization. |
| X_LEGISLATION_CODE | LEGISLATION_CODE | Optionally, you can enter a legislation code to restrict to which business groups the EIT is available. If you do not enter a legislation code it will be valid for all business groups. |
| X_DESTINATION | DESTINATION | This is set to Null. |
| X_FND_APPLICATION_ID | FND_APPLICATION_ID | ID of application. |
| X_CREATION_DATE | CREATION_DATE | Creation date. |
| X_CREATED_BY | CREATED_BY | Created by (user ID). |
| X_LAST_UPDATE_DATE | LAST_UPDATE_DATE | Date of last update. |
| X_LAST_UPDATED_BY | LAST_UPDATED_BY | User ID of last person to update table. |
| X_LAST_UPDATE_LOGIN | LAST_UPDATE_LOGIN | ID for the login session |
Specify for which organization classifications this EIT should be available.
To do this, enter a row into HR_ORG_INFO_TYPES_BY_CLASS as shown in the following table:
| Column name | Description |
|---|---|
| ORG_CLASSIFICATION | ORG_CLASS lookup code |
| ORG_INFORMATION_TYPE | Org extra information type |
| MANDATORY_FLAG | Y (for Yes) or N (for No) |