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

Last updated on MAY 15, 2016

Applies to:

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

Symptoms

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.

ERROR

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.

STEPS

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

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