Editing picklists

Editing picklists in Oracle Eloqua enables you to update, add, remove, or reorder the options available to users and customers. Keeping your picklists current helps ensure consistent data quality and user experience.

Good to know:

  • For large picklists or lists where you are making many changes, consider exporting the list and re-importing it to save time.

  • The classic UI allows up to 2,500 values per picklist. The Redwood experience displays a maximum of 500 values per picklist. Lists larger than 500 in Redwood can only be managed by uploading values.
  • In the Redwood experience, you cannot have duplicate options (the same display name with different stored values). If your use case requires duplicate picklist options, a Controlled Availability (CA) setting is available. Contact Oracle Support to have this enabled.

To edit a picklist:

  1. Click Settings An image of the Settings menu icon, which is represented by a black cog..

  2. Click Manage Picklists in the Database Setup area.

  3. Open the picklist you want to edit.

  4. Make edits as needed.

    • To change the security settings:

      • In the classic UI, click Picklists and then click Edit Security.

      • In the Redwood experience, click > Edit Permissions.

    • To create new values:
      • In the classic UI, use Add Option.
      • In the Redwood experience, click Add Options.
    • To copy options from another picklist to this one:
      • In the classic UI, click Picklists and then click Copy Values From Another List.
      • In the Redwood experience, click Copy Options.
    • To upload values:
      • In the classic UI, click Picklists and then click Upload Picklist.
      • In the Redwood experience, click Upload Options. Learn more.
  5. Save your changes.

Learn more

Picklists