Good question came about between myself and a very respected development consultant friend of mine regarding design of Single row User Defined Attribute Groups (UDA groups) and Multi row UDA groups.
The SR (single row) are used for those items that occur only once such as a synchronization group used to show the item’s status, item id, and date in each spoke system. Where MR (multi row) groups are used to provide zero to ‘n’ number of instantiations of the UDA group rows per item. What other examples of MR groups have you run into at other client sites?
My responses had to be client confidential of course.
In some cases multi row UDA groups are created to store dynamic item definition that cannot be predefined into specific columns because of their dynamic nature. Such as, the use of a MR to show the number of colors available to a item when color is not a unique item option. Another use of MR groups, is to show the number of countries that an item is allowed to be sold in and allowed to be shipped-to. Another example of MR is to show historical effectivity within spoke CRM sales order systems outside the PIM Hub. One final (for blog brevity purposes only) is to dynamically be able to add the data but also prioritize and order the data with additional attributes.
They have also been used to add Structure component attribute data to an item because the import of SR and MR component structure data is impossible off the shelf in R12.1.3. The client is forced to use the parent/assembly item to store the component structure data in an MR on the assembly item itself.
I have seen clients choose one or the other for the same actual purpose. Some clients have choices forced by the legacy system that is feeding or is getting fed. Some SR choices are made by the fact there are only three choices maximum so the client chooses to add three attributes to a single row attribute group in order to absolutely force the capacity.
Happy belated Valentine’s Day to everyone!
I arrived at my hotel room to see flowers, chocolate, teddy bear, and a beautiful card from my wife and children. The road is hard but sometimes has its joys.
- How many columns for UDA Groups in 12.1.2? (mckinleyalexandra.wordpress.com)