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.
ORA-01007: Variable Not In Select


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. 

* This error appears if this attribute group has PRE or POST events defined.

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


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.