Maintain existing and define additional Lookups for your shared Lookup types. You can define up to 250 Lookups for each Lookup type. Each Lookup has a code and a meaning. For example, Lookup type YES_NO has a code Y with meaning Yes, and a code N with a meaning No.
Note: In Releases 11.0 and earlier, there were two Lookup features, Special Lookups and Common Lookups. These two features have been merged into one. The new consolidated Lookups feature has Lookups maintained in this form.
If you make changes to a Lookup, users must log out then log back on before your changes take effect.
Lookups Block
Type
Query the type of your Lookup. You can define a maximum of 250 Lookups for a single type.
User Name
The user name is used by loader programs.
Application
Query the application associated with your Lookup type.
Description
If you use windows specialized for a particular Lookup type, the window uses this description in the window title.
Access Level
The access level restricts changes that are possible to a lookup type. The possible levels are:
System
No changes to the lookup codes are allowed.
Extensible
New lookup codes can be added. However, you cannot modify seeded lookup codes.
User
You can change any lookup code.
Security Group
This field is for HRMS security only. See: Customizing, Reporting, and System Administration in Oracle HRMS.
Only the security group of the current form session can be maintained using this form. Standard is the standard default security group. Custom indicates this lookup type is for a custom security group.
All global and cross-security group maintenance is done using the Generic Loader with the Lookups configuration file.
Lookups Values Block
Suggestion: If you would like to query records by a code attribute, such as the Enabled check box, then do the following:
Step 8. Query the lookup type.
Step 9. Move the cursor to any field in the lower region on the window.
Step 10. From the View menu, select Query By Example, Enter.
Step 11. Enter your query criteria.
Step 12. From the View Menu, select Query By Example, Run.
Code
Enter the code value for your Lookup. You can define a maximum of 250 Lookups for a single Lookup type. When you enter a valid Lookup meaning into a displayed window field, Lookups stores this code into a corresponding hidden field. For example, the Lookup "Y" displays the meaning "Yes" but stores the code value "Y" in a hidden field.
You cannot change the values in this field after committing them. To remove an obsolete Lookup you can either disable the code, enter an end date, or change the meaning and description to match a replacement code.
Meaning
When you enter a valid Lookup meaning into a displayed window field, Lookups stores the corresponding code into a hidden field. Lookups automatically displays the meaning in your Lookups field whenever you query your window. For example, the Lookup "Y" displays the meaning "Yes" but stores the code value "Y" in a hidden field.
Description
You can display the description along with the meaning to give more information about your Lookup.
Tag
Optionally enter in a tag to describe your lookup. The tag can be used to categorize lookup values.
Effective Dates
Enter the dates between which this Lookup becomes active. If you do not enter a start date, your Lookup is valid immediately.
Once a Lookup expires, users cannot insert additional records using the Lookup, but can query records that already use the Lookup. If you do not enter an end date, your Lookup is valid indefinitely.
Enabled
Indicate whether applications can use your Lookup. If you enter No, users cannot insert additional records using your Lookup, but can query records that already use this Lookup.
[ ]
The double brackets ([ ]) identify a descriptive flexfield that you can use to add data fields to this window without programming.
Note: In Releases 11.0 and earlier, there were two Lookup features, Special Lookups and Common Lookups. These two features have been merged into one. The new consolidated Lookups feature has Lookups maintained in this form.
If you make changes to a Lookup, users must log out then log back on before your changes take effect.
Lookups Block
Type
Query the type of your Lookup. You can define a maximum of 250 Lookups for a single type.
User Name
The user name is used by loader programs.
Application
Query the application associated with your Lookup type.
Description
If you use windows specialized for a particular Lookup type, the window uses this description in the window title.
Access Level
The access level restricts changes that are possible to a lookup type. The possible levels are:
System
No changes to the lookup codes are allowed.
Extensible
New lookup codes can be added. However, you cannot modify seeded lookup codes.
User
You can change any lookup code.
Security Group
This field is for HRMS security only. See: Customizing, Reporting, and System Administration in Oracle HRMS.
Only the security group of the current form session can be maintained using this form. Standard is the standard default security group. Custom indicates this lookup type is for a custom security group.
All global and cross-security group maintenance is done using the Generic Loader with the Lookups configuration file.
Lookups Values Block
Suggestion: If you would like to query records by a code attribute, such as the Enabled check box, then do the following:
Step 8. Query the lookup type.
Step 9. Move the cursor to any field in the lower region on the window.
Step 10. From the View menu, select Query By Example, Enter.
Step 11. Enter your query criteria.
Step 12. From the View Menu, select Query By Example, Run.
Code
Enter the code value for your Lookup. You can define a maximum of 250 Lookups for a single Lookup type. When you enter a valid Lookup meaning into a displayed window field, Lookups stores this code into a corresponding hidden field. For example, the Lookup "Y" displays the meaning "Yes" but stores the code value "Y" in a hidden field.
You cannot change the values in this field after committing them. To remove an obsolete Lookup you can either disable the code, enter an end date, or change the meaning and description to match a replacement code.
Meaning
When you enter a valid Lookup meaning into a displayed window field, Lookups stores the corresponding code into a hidden field. Lookups automatically displays the meaning in your Lookups field whenever you query your window. For example, the Lookup "Y" displays the meaning "Yes" but stores the code value "Y" in a hidden field.
Description
You can display the description along with the meaning to give more information about your Lookup.
Tag
Optionally enter in a tag to describe your lookup. The tag can be used to categorize lookup values.
Effective Dates
Enter the dates between which this Lookup becomes active. If you do not enter a start date, your Lookup is valid immediately.
Once a Lookup expires, users cannot insert additional records using the Lookup, but can query records that already use the Lookup. If you do not enter an end date, your Lookup is valid indefinitely.
Enabled
Indicate whether applications can use your Lookup. If you enter No, users cannot insert additional records using your Lookup, but can query records that already use this Lookup.
[ ]
The double brackets ([ ]) identify a descriptive flexfield that you can use to add data fields to this window without programming.
Thank you for sharing this informative piece! Eagerly anticipating more content that bridges theory and hands-on application in the context of online training for Fusion Cloud SCM online training.
ReplyDelete