1 Reply Latest reply: Aug 1, 2014 10:52 AM by Kellymayfield-Oracle RSS

    Unmarking Distinct on an active extended attribute

    Jeff Schweid

      I have an extended attribute that was incorrectly marked distinct.  When I go in to edit the EA, I am unable to uncheck distinct.  I am trying  to make it not distinct so I can create a repeatable row in a custom section.

        • 1. Re: Unmarking Distinct on an active extended attribute
          Kellymayfield-Oracle

          There's no way to do this within the UI once an EA has been activated. We lock this function down because the EA could be consumed on objects and those objects rely on the distinct flag for specific behavior, like formulation calculations.  You have to use a database script to remove the distinct flag.  I'll have to defer to dev for an exact script, but it should be pretty straight forward.   Before making it non distinct make sure the EA isn't being used for formulation calculations or being relied on for reports etc.