Database Error ORA-01007 when Downloading Oracle Product Hub Attribute Group(s) Through FNDLOAD Utility (Doc ID 1947331.1)

Last updated on MARCH 08, 2019

Applies to:

Symptoms

When attempting to download attribute group(s) through FNDLOAD utility, the following error is raised in the request log and the output LDT file does not contain the attribute group details.

Error
[
A database error occurred:
ORA-01007: variable not in select list

The error occurred while defining column 22 in the following statement:
 SELECT FL_COL.END_USER_COLUMN_NAME ATTR_NAME
  ,FL_COL.APPLICATION_COLUMN_NAME DATABASE_COLUMN
  ,EXT.DATA_TYPE DATA_TYPE_CODE
  ,TL.FORM_LEFT_PROMPT ATTR_DISPLAY_NAME
  ,TL.DESCRIPTION DESCRIPTION
  ,FL_COL.COLUMN_SEQ_NUM SEQUENCE
  ,FL_COL.REQUIRED_FLAG REQUIRED_FLAG
  ,EXT.SEARCH_FLAG SEARCH_FLAG
  ,FFVS.FLEX_VALUE_SET_NAME VALUE_SET_NAME
  ,EXT.INFO_1 INFO_1
  ,FL_COL.DEFAULT_VALUE DEFAULT_VALUE
  ,EXT.UNIQUE_KEY_FLAG UNIQUE_KEY_FLAG
  ,FL_COL.ENABLED_FLAG ENABLED_FLAG
  ,FL_COL.DISPLAY_FLAG DISPLAY_CODE
  ,EXT.UOM_CLASS UOM_CLASS
  ,EXT.ATTRIBUTE_CODE ATTRIBUTE_CODE
  ,EXT.VIEW_IN_HIERARCHY_CODE VIEW_IN_HIERARCHY_CODE
  ,EXT.EDIT_IN_HIERARCHY_CODE EDIT_IN_HIERARCHY_CODE
  ,EXT.CUSTOMIZATION_LEVEL CUSTOMIZATION_LEVEL
  ,TO_CHAR(EXT.LAST_UPDATE_DATE, 'YYYY/MM/DD HH24:MI:SS') ATTR_LUD
  ,FND_LOAD_UTIL.OWNER_NAME(EXT.LAST_UPDATED_BY) ATTR_OWNER
  FROM FND_DESCR_FLEX_COLUMN_USAGES FL_COL
  ,FND_DESCR_FLEX_COL_USAGE_TL TL
  ,EGO_FND_DF_COL_USGS_EXT EXT
  ,FND_FLEX_VALUE_SETS FFVS
  WHERE FL_COL.APPLICATION_ID = TL.APPLICATION_ID
  AND FL_COL.DESCRIPTIVE_FLEXF
]

Steps
Run the following command:
FNDLOAD apps/@ 0 Y DOWNLOAD $EGO_TOP/patch/115/import/egoefag.lct .ldt ATTRIBUTE_GROUP APPLICATION_ID=431 ATTR_GROUP_TYPE=EGO_ITEMMGMT_GROUP ATTR_GROUP_NAME=XXX

Cause

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