Custom Flex Attribute Script CFAGEN Produces 'ORA-00957: Duplicate Column Name' Error

(Doc ID 1920363.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.2.5 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.


The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.

When attempting to create Custom Flex Attributes (CFAS) at the Order Head level, the generated script CFAGEN produces the following error:

Steps to Reproduce:

1. Configure CFAS attributes as per requirement with appropriate labels and display sequence.
2. Run the cfagen.ksh.
3. Validate the script and follow the normal process to activate in RMS by running the script in the backend.
4. Note the error.


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