To Create Lookup Types:

1. Select an item type from the navigator tree and choose New Lookup Type from the Edit menu. A Lookup Type property page appears.

2. Lookup types have an all-uppercase Internal Name with no leading/trailing spaces and a translatable Display Name. All Oracle Workflow APIs, SQL scripts, and PL/SQL procedures refer to the internal name when identifying a lookup type.

   The internal name and the display name for a lookup type must both be globally unique across all item types. You may find it useful to include a prefix such as the item type name to ensure that the lookup type internal name and display name are unique.

   Important: To update the internal name for a lookup type once it is defined, you must use a special SQL script called wfchlut.sql. You should only use this script to correct errors in a lookup type's internal name during design time. Do not use this script to rename lookup types that are involved in running instances of processes. See: Wfchlut.sql.

   Caution: Do not include colons ":" or leading/trailing spaces in your internal name.

   You can supply an optional description for this lookup type.

3. Select the Access tab page to set the access levels allowed to modify this lookup type. See: Allowing Access to an Object.

4. Choose Apply to save your changes, OK to save your changes and close the property page, or Cancel to cancel your changes and close the property page.

5. The lookup type you just defined now appears beneath the Lookup Types branch in the navigator tree. You can review or edit the properties of this lookup type at any time by double-clicking on the lookup type in the navigator tree or by selecting the lookup type and choosing Properties from the Edit menu.

6. Now define the lookup codes for your lookup type. See: To Create Lookup Codes for a Lookup Type.

   To Create Lookup Codes for a Lookup Type:

1. Select a lookup type from the navigator tree and choose New Lookup Code from the Edit menu. A Lookup Code property page appears.

2. Enter an Internal Name with no leading/trailing spaces and a Display Name for the lookup code. You can also enter an optional description. All Oracle Workflow APIs, SQL scripts, and PL/SQL procedures refer to the internal name when identifying a lookup code.

   Important: To update the internal name for a lookup code once it is defined, you must use a special SQL script called wfchluc.sql. You should only use this script to correct errors in a lookup code's internal name during design time. Do not use this script to rename lookup codes that are involved in running instances of processes. See: Wfchluc.sql.

   Caution: Do not include colons ":" or leading/trailing spaces in your internal name.

3. Choose Apply to save your changes, OK to save your changes and close the property page, or Cancel to cancel your changes and close the property page.

4. The lookup code you just defined now appears beneath the lookup type you created it for in the navigator tree. You can review or edit the properties of this lookup code at any time by double-clicking on the lookup code in the navigator tree or by selecting the lookup code and choosing Properties from the Edit menu.

5. Repeat steps 1, 2, and 3 if you wish to create additional lookup codes for a specific lookup type.

   To Copy a Lookup Type:

1. Select the lookup type to copy in the navigator tree.

2. Use the Copy and Paste options in the Edit menu to copy and paste the lookup type to the item type you want. You can also drag and drop the lookup type to the item type you want.

   • If you copy a lookup type back to the same item type, or if you copy a lookup type to an item type in a different data store when the lookup type already exists in any item type in that data store, then the property page appears for you to enter a unique internal and display name for the new lookup type. When you are done, choose OK.

   • If you copy a lookup type to an item type in a different data store, and that lookup type does not yet exist in any item type in that data store, then the new lookup type is copied with the same internal and display name as the original. You do not have to enter new names.

   Note: Copying a lookup type also copies any lookup codes assigned to it.

   Note: You cannot use the Copy and Paste options to copy a lookup type to another item type in the same data store. However, you can drag and drop a lookup type to another item type in the same data store; by doing so, you actually move the lookup type to the new item type.

   To Copy a Lookup Code:

1. Select the lookup code to copy in the navigator tree.

2. Hold down your mouse select button as you drag the lookup code to the lookup type you want to copy it to.

3. If you drag the lookup code to the same lookup type or to a lookup type where this code already exists, then when you release your mouse button, a properties page appears for you to enter a unique internal and display name the new lookup code. When you are done, choose OK.

   Note: You can also use the Copy and Paste options in the Edit menu.