Database Error ORA-01007 when Downloading Oracle Product Hub Attribute Group(s) Through FNDLOAD Utility
(Doc ID 1947331.1)
Last updated on SEPTEMBER 11, 2019
Applies to:
Oracle Product Hub - Version 12.1.3 and laterInformation in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |
References |