My Oracle Support Banner

Problems With Table Validated Value Set For Variant Attributes (Doc ID 1347641.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Product Hub - Version and later
Information in this document applies to any platform.


When attempting to set up a table validated valueset, making use of the $OBJECT$ functionality -- this works perfectly for a standard attribute.
However, it is not working for a variant attribute. The following error occurs.


There was an error with the sql query for Attribute MARKET_LANG: The bind value INVENTORY_ITEM_ID in sql query SELECT InternalName, DisplayName, Description From ( SELECT modlan InternalName, modlan DisplayName, null Description FROM MTL_SYSTEM_ITEMS_B A, EGO_MOD_IT_AGV B, EGO_MODLAN_AGV C WHERE A.INVENTORY_ITEM_ID=:$OBJECT$.INVENTORY_ITEM_ID AND A.ORGANIZATION_ID=:$OBJECT$.ORGANIZATION_ID AND A.SEGMENT1 = B.MOD_IT_DISP AND A.ORGANIZATION_ID = B.ORGANIZATION_ID AND B.INVENTORY_ITEM_ID = C.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = C.ORGANIZATION_ID ) is not a valid Attribute or a primary key column. Please notify a system administrator of this problem.


The issue can be reproduced at will with the following steps:

  1. Create value set with $OBJECT$ functionality
  2. Use this value set for standard attribute > it works fine
  3. Use this value set for variant attribute > it goes in error


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

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