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
-
In the Setup and Maintenance work area, go to the Manage Descriptive Flexfields task in the Application Extensions functional area.
-
On the Manage Descriptive Flexfield page, use the Search text field to search for FND_LOOKUP_VALUES_B descriptive flexfield.
-
Select the descriptive flexfield and click the Edit icon.
-
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
-
Click Manage Contexts.
-
On the Manage Contexts page, go to the Search Results section and click the Create icon.
-
On the Create Context page, enter the context code as US_STATE.
-
Click Save and Close.
Create the Context Sensitive Segments
-
On the Manage Contexts page, go to the Search Results section and select the US_STATE context code.
-
Click the Edit icon.
-
On the Edit Context page, go to the Context Sensitive Segments section and click the Create icon.
-
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
-
Click Save and Close.
-
On the Manage Contexts page, click Save and Close.
-
On the Edit Descriptive Flexfield page, click Save and Close.
Deploy the Changes
-
On the Manage Descriptive Flexfield page, click Deploy Flexfield to deploy the changes made in the FND_LOOKUP_VALUES_B descriptive flexfield.
-
In the confirmation window, click OK.
-
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.
-
In the Setup and Maintenance work area, go to the Manage Common Lookups task in the Application Extensions functional area.
-
On the Manage Common Lookups page, use the Search text field to search for the US_STATE lookup type.
-
Select the US_STATE lookup type.
-
Go to the Lookup Codes section and click the New icon.
-
In the Lookup Code field, enter AZ.
-
In the Meaning field, enter the meaning of the lookup code as Arizona.
-
Click Save.
-
Click the Expand icon to the left of the newly added lookup code.
-
In the Capital field, enter Phoenix.
-
Click Save and Close.