Incorrect CFAS LOV Validation When Multiple Attribute Groups For The Same Group Is Set (Doc ID 1418194.1)

Last updated on MAY 18, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.2.3 and later
Information in this document applies to any platform.

Symptoms

If setting up two Custom Flex Attribute Setup (CFAS) Groups for a single Group set within an entity and the first Group has multiple LOV attributes based on Record Groups and the second Group has a Checkbox attribute in the same position (i.e. same variable) as the first Group, then LOV validation will fire upon the checkbox when moving to the second group. This is being caused by the VALIDATE_FROM_LIST property of the variable being set to TRUE for the first Group for the same variable that is used for the Checkbox in the second group. The FLEX_UI.SET_ATTRIB_FIELD_PROPERTY will be fired for the first set of attributes and the VALIDATE_FROM_LIST for VARCHAR2_2 will be set to TRUE and this property is never reset for the second Group of attributes.

Steps to Reproduce

1) Create an Attribute Group for a Group Set defined for an Entity. For example, create Group €˜Personnel Attributes€™ for the €˜Polaris Attributes Maintenance€™ Group Set defined for the Supplier Entity. Have 2 attributes in the €˜Personnel Attributes€™ group both being List of Values based upon Record Groups defined from the CFA_CODE_DETAIL_DESCS table.


2) Create a second Attribute Group for a Group Set defined for an Entity. For example, create Group €˜Master Attributes€™ for the €˜Polaris Attributes Maintenance€™ Group Set defined for the Supplier Entity. have 3 attributes in the €˜Master Attributes€™ group and make sure the second attribute is a Check Box.

3) Test the attributes using the €˜View UI€™ capability in the Attribute Maintenance (cfaattrsetup) screen. Notice the First Attribute Group displays fine.

4) Now move the cursor to the second attribute group and notice that an LOV dialogue screen appears. The LOV is the one defined for the VARCHAR_2 field in the first attribute group. This fires on the Check Box field (Discontinue Vendor) because by default a check box field will be set to '€˜N'€™ and since '€˜N'€™ is not a valid value as defined in the record group, the dialogue will appear. This is firing because the VALIDATE_FROM_LIST property of VARCHAR2_2 has been set for the previous group and is never reset prior to moving to a new group.

5) Since the default value of the Check Box field is '€˜N'€™ and since the VALIDATE_FROM_LIST property is true, then validation will be performed looking for '€˜N'€™ in the record group defined for the VARCHAR2_2 field in the first group. This is also based on an LOV_NAME property not being reset either.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms