Configure Descriptive Flexfield Segments for a Lookup Type

Depending on the configuration level of a lookup type, you can configure the lookup codes or their meanings.

To capture more information for the lookup type, you can also configure the descriptive flexfield segments for the lookup type. For example, let's configure the descriptive flexfield segments for the US_STATE lookup type. Here are the tasks we need to do:

• Create the US_STATE context code

• Create the context-sensitive segments

• Deploy the changes

• Add a context segment value for the lookup type

Create the US_STATE Context Code

1. In the Setup and Maintenance work area, go to the Manage Descriptive Flexfields task in the Application Extensions functional area.

2. On the Manage Descriptive Flexfield page, use the Search text field to search for FND_LOOKUP_VALUES_B descriptive flexfield.

3. Select the descriptive flexfield and click the Edit icon.

4. On the Edit Descriptive Flexfield page, go to the Context Segment section and specify these values:

   Field	Value
   Default Type	Parameter
   Default Value	LookupType
   Derivation Value	LookupType
   Display Type	List of Values

5. Click Manage Contexts.

6. On the Manage Contexts page, go to the Search Results section and click the Create icon.

7. On the Create Context page, enter the context code as US_STATE.

8. Click Save and Close.

Create the Context Sensitive Segments

1. On the Manage Contexts page, go to the Search Results section and select the US_STATE context code.

2. Click the Edit icon.

3. On the Edit Context page, go to the Context Sensitive Segments section and click the Create icon.

4. On the Create Segment page, specify these values:

   Field	Value
   Code	Capital
   Data type	Character
   Value Set	GL_100_CHARACTERS
   Default Type	Parameter
   Default Value	LookupType
   Derivation Value	LookupType
   Display Type	List of Values

5. Click Save and Close.

6. On the Manage Contexts page, click Save and Close.

7. On the Edit Descriptive Flexfield page, click Save and Close.

Deploy the Changes

1. On the Manage Descriptive Flexfield page, click Deploy Flexfield to deploy the changes made in the FND_LOOKUP_VALUES_B descriptive flexfield.

2. In the confirmation window, click OK.

3. Sign out and sign back in to see the changes.

Add a Context Segment Value for the Existing Lookup Type

After you add a new lookup code for the US_STATE lookup type, the context segment appears for the new lookup code. You can add value to the context segment.

1. In the Setup and Maintenance work area, go to the Manage Common Lookups task in the Application Extensions functional area.

2. On the Manage Common Lookups page, use the Search text field to search for the US_STATE lookup type.

3. Select the US_STATE lookup type.

4. Go to the Lookup Codes section and click the New icon.

5. In the Lookup Code field, enter AZ.

6. In the Meaning field, enter the meaning of the lookup code as Arizona.

7. Click Save.

8. Click the Expand icon to the left of the newly added lookup code.

9. In the Capital field, enter Phoenix.

10. Click Save and Close.