My Oracle Support Banner

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 APRIL 16, 2021

Applies to:

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


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.



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.