My Oracle Support Banner

Import Items Error: Ego_item_user_attrs_cp_pub.process_item_user_attrs_data: ORA-01007: Variable Not In Select (Doc ID 2234046.1)

Last updated on FEBRUARY 15, 2017

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.
Ego_item_user_attrs_cp_pub.process_item_user_attrs_data
ORA-01007: Variable Not In Select

Symptoms

Receive an error creating items using Public API EGO_USER_ATTRS_PUB.Process_User_Attrs_Data and a user defined attribute (print part) is not populated. 

Error
ORA-01007
* This error appears if this attribute group has PRE or POST events defined.

Steps
1. Development Manager > Create Item
2. Notice that the print part attribute should be populated but it is not

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!


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