Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Restrictions When Using Concatenated Fields

The following restrictions apply when using concatenated fields:

  • Concatenated fields support only the following field types:
    • Address
    • Currency
    • Date/Date Time
    • Integer
    • Number
    • Percent
    • Picklist
    • Text (Long)
    • Text (Short)

      NOTE: The Sales Stage field is not a true picklist field. Concatenated fields are not supported on this type of picklist.

  • The combined total of Web links and concatenated fields that you can create varies with the record type, but for some record types the combined total is 100 Web links and concatenated fields. For more information about fields in Oracle CRM On Demand, see About Custom Fields.
  • Concatenated fields cannot be updated through Update Values workflow actions, and cannot be included in integration events. Instead, you must use the individual fields that make up the concatenated fields.
  • You cannot import or export concatenated fields in Oracle CRM On Demand. However, you can import and export the individual fields that make up the concatenated fields.
  • When setting up a concatenated field with an address field, the following conditions apply:
    • You can add individual fields from an address, or more than one address, to a concatenated field.
    • Only the address fields that you add to the concatenated field appear in the concatenated field. However, when a user updates that concatenated field, the user can edit all of the fields in the relevant address templates, not just the address fields that appear in the concatenated field, unless the field is from a shared address. If an address field in a concatenated field is from a shared address on an account, contact, dealer, or partner record, then the user cannot edit the fields within the address. Instead, the user can select a different address.
  • When setting up a concatenated field with a cascading picklist, all the picklists associated with the cascading picklist must be added to the concatenated field. If you do not add all the picklists, then they remain read-only, and cannot be edited.

Related Topics

See the following topics for related information:


Published 7/3/2018 Copyright © 2005, 2018, Oracle. All rights reserved. Legal Notices.