Problems With Table Validated Value Set For Variant Attributes
Last updated on DECEMBER 19, 2017
Applies to:Oracle Product Hub - Version 220.127.116.11 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:
- Create value set with $OBJECT$ functionality
- Use this value set for standard attribute > it works fine
- Use this value set for variant attribute > it goes in error
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