In Oracle Fusion Supply Chain Management (SCM), lookup types and lookup codes are used to define and manage various reference data values, such as statuses, types, categories, and other attributes. Lookups allow you to configure and customize Oracle Fusion SCM to meet your organization’s specific needs. Here’s an overview of lookups in Oracle Fusion SCM:

1. Lookup Types: Lookup types are categories or groups of related lookup codes. Each lookup type represents a specific type of reference data. For example, you might have lookup types for “Order Status,” “Item Types,” or “UOM (Unit of Measure) Classes.” These lookup types help organize and group related lookup codes together.
2. Lookup Codes: Lookup codes are individual values within a lookup type. They represent specific options or values for a particular attribute or field. For example, within the “Order Status” lookup type, you might have lookup codes like “Open,” “Shipped,” “Delivered,” etc. These codes are used to populate dropdown lists, control behavior, and define valid values throughout the application.

Here’s how you can work with lookups in Oracle Fusion SCM:

• Viewing Lookups: You can view and search for lookup types and codes through the Oracle Fusion Applications user interface. Navigate to the relevant setup area (e.g., Order Management, Inventory, Procurement) and find the “Manage Lookups” or similar option. From there, you can view existing lookup types and codes.
• Creating and Modifying Lookups: Depending on your security and setup permissions, you can create new lookup types and codes or modify existing ones. This allows you to customize the application to match your business requirements.
• Assigning Lookups: After defining lookup codes, you can assign them to various fields, attributes, or processes within Oracle Fusion SCM. For example, you can assign a lookup code for “Order Status” to a status field in your order management process.
• Validation Rules: Lookups can be used in validation rules and workflows to ensure that data entered into the system conforms to predefined values.
• Reporting and Analytics: Lookups are often used in reporting and analytics to categorize and filter data based on specific attributes or statuses.