Record Type Fields
Using Application Composer, you can add a record type field to both standard or custom objects. A record type field contains a list of static values which are populated from FND lookup types.
This type of field is useful because you can associate each choice list value with a role or a page layout. Associating a choice list value with a role means that only users with that role can see the choice list value. Associating a choice list value with a page layout means that once that value is selected at runtime, the associated page layout displays. This makes a record type field more powerful than a fixed choice list field or a dynamic choice list field.
Using Record Type Fields
Create a record type field, so that you can associate each choice list value with a role or a page layout.
You can:
-
Associate each choice list value with a role.
-
You do this while you're creating the field.
-
At runtime, when an end user views the list of values in the field, the available choices are constrained according to the user's role.
Custom roles, which are copies of the predefined roles that Oracle provides for all customers, are displayed by default. However, you can optionally choose to display predefined roles, as well.
-
-
Associate each choice list value with a page layout.
-
You do this by adding the field to a application page layout, after you have created the field.
-
You must then assign a choice list value to the page layout.
-
At runtime, when an end user selects a value from the field, the page display changes to match the application page layout that you associated with the choice list value.
-
Record Type Field Properties
Create a record type field by specifying values for the common set of field properties, such as display label and field name. You also set properties for this field that are specific to the record type field type.
The following properties are common across multiple field types:
Field Property |
Field Property Region |
---|---|
Label |
Appearance |
Help Text |
Appearance |
Display Width |
Appearance Note: Do not use. A field's display width is dynamically
calculated based on the field type and resolution.
|
Name |
Name |
Description |
Name |
Required |
Constraints |
Updatable |
Constraints |
Searchable |
Constraints |
Fixed Value |
Default Value |
The following properties are unique to only certain field types, including record type fields:
Field Property |
Field Property Region |
---|---|
Lookup Type Selecting the lookup type is possible only during field creation. |
List of Values |
Available Record Types Indicate the choice list values that each role has access to. For example, perhaps the sales representative can see only selected choice list values, but the sales manager can see all the choice list values. |
Roles |
Default Record Type Indicate the choice list value that each role will see by default at runtime. |
Roles |
Using the List of Values Region
The values in a record type field are populated from FND lookup types. Select the lookup type whose values you want to display in this choice list.
You can also select a lookup type and select the Edit icon to modify the existing values.
Or, create a new lookup type and add new values to it.
Additional Record Type Field Specifications
Additional specifications for this field type include the following details:
-
Data type is VARCHAR2 (1500).
-
A record type field is optional, and isn't required for an object.
-
One record type field is allowed per object, and it will be one of the 350 fields reserved for text and check box fields, and fixed and dynamic choice lists.