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

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