CFA Validation Does Not Work As CFA_SQL.GET_VALUE Does Not Get the Attribute Value Provided by User

(Doc ID 2295168.1)

Last updated on AUGUST 11, 2017

Applies to:

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

Symptoms

CFA(Custom Flex Attributes) Validation does not work as the attribute value is returned as null by CFA_SQL API.

Steps to reproduce:

  1. Setup CFA group set for Item Master.
  2. Setup CFA group  for above defined group set
  3. Setup number type attributes for the above group.
  4. Create a custom validation function which validates the sum of attributes provided by user is 100%.
  5. Setup the above defined function as Validation_func in Group set.
  6. Now run the cfagen.ksh to activate the CFA.
  7. Navigate to Item screen --> More Action --> Other attributes -- CFAS screen.
  8. Enter the below values in the CFA screen such that the total value is 100.  
    • Attribute1 % = 6 
    • Attribute2 % = 40
  9. After clicking "Save & Close", a error message pops up saying total% is not equal to 100.

 

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