Generated SQL Files by Cfagen.ksh Are Missing First Column of Table/View DDLs and No Synonym DDL (Doc ID 2079057.1)

Last updated on DECEMBER 18, 2015

Applies to:

Oracle Retail Merchandising System - Version 14.0 to 14.0.2 [Release 14.0]
Information in this document applies to any platform.

Symptoms

Missing first column in SQL file generated by CFAGEN.KSH.

Steps to Recreate:

  1. Create a new Custom Flex Attribute (CFA) for a table of your choice (e.g., REGION)
  2. Run CFAGEN.ksh batch
  3. The generated SQL file has a missing first column name
  4. Also the synonyms do not get created

 

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