Picklists
Picklists in Oracle Eloqua are predefined lists of values that streamline and standardize data entry. By providing consistent options for fields such as region, industry, or product line, picklists reduce entry errors, improve reporting accuracy, and ensure uniformity across campaigns, forms, and records.
Types of picklists:
-
Picklists - Centrally managed lists available for reuse across multiple forms, fields, or campaigns within Eloqua. Updates to a picklist automatically apply wherever the picklist is used.
-
Quicklists - Local lists created within a specific form or field. Quicklists only exist in the context where they are created, and changes to a quick list do not affect other forms or fields.
Use picklists for any value set that will be reused across the organization. Use quicklists for unique, one-off requirements within a single filter or asset.
Examples
- For Eloqua users: Picklists standardize field values during campaign setup, segmentation, and when managing or importing data records.
- For customers (form submitters): When added to forms (such as event registrations or lead capture), picklists present selectable options for customers, ensuring you receive clean and normalized data.
Best practices and sizing recommendations
-
Use Clear Names: Choose descriptive names for picklists and options to minimize user confusion. Picklist names must be unique.
-
Avoid Duplicate Options: Duplicate options can be confusing to your users or customers. In the Redwood experience, we prevent adding duplicate option names (display value) with different option values (stored values). If your use case requires duplicate options, a Controlled Availability (CA) setting is available. Contact Oracle Support to have this enabled.
-
Limit Picklist Length: Keep the length of picklists concise. Aim for under 25 values where practical for ease of use. Avoid exceeding 2500 picklist option, as larger lists may ause performance issues for the UI and for processes using the picklist.
-
The classic UI allows up to 2,500 values per picklist.
-
The Redwood experience displays a maximum of 500 values per picklist. Larger lists can be managed using upload options.
-
-
Centralize Values: Use picklists for any values used in multiple areas to simplify updates. Quicklists should only be used for short lists that won't be reused.
-
Limit Quicklist Length: Keep quicklists to less than 2500 values. Any values over that amount may be lost when an asset is modified, and will not be displayed in the UI.