Error In Value Set Using $ATTRIBUTEGROUP$ (Doc ID 2000398.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Site Hub - Version 12.1.3 and later
Oracle Property Manager - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Defined value set XXSEI_STORE_LETTER_CODE, based on a query on FND_FLEX_VALUES V. The where clause is as follows

V.FLEX_VALUE_SET_ID IN (SELECT F.FLEX_VALUE_SET_ID FROM APPS.FND_FLEX_VALUE_SETS F WHERE F.FLEX_VALUE_SET_NAME = DECODE(:$ATTRIBUTEGROUP$.XXSEI_CONTRACT_PARTY_TYPE,'FRANCHISEE','XXSEI_FRANCHISEE_LETTER_CODE','CORPORATE','XXSEI_CORPORATE_LETTER_CODE'))
 
However, when navigating to the page, get an error

ERROR
--------
There was an error with the sql query for Attribute XXSEI_CONTRACT_PARTY_TYPE,'FRANCHISEE','XXSEI_FRANCHISEE_LETTER_CODE','CORPORATE','XXSEI_CORPORATE_LETTER_CODE')): The bind value XXSEI_CONTRACT_PARTY_TYPE,'FRANCHISEE','XXSEI_FRANCHISEE_LETTER_CODE','CORPORATE','XXSEI_CORPORATE_LETTER_CODE')) in sql query V.FLEX_VALUE_SET_ID IN (SELECT F.FLEX_VALUE_SET_ID FROM APPS.FND_FLEX_VALUE_SETS F WHERE F.FLEX_VALUE_SET_NAME = DECODE(:$ATTRIBUTEGROUP$.XXSEI_CONTRACT_PARTY_TYPE,'FRANCHISEE','XXSEI_FRANCHISEE_LETTER_CODE','CORPORATE','XXSEI_CORPORATE_LETTER_CODE')) is not a valid Attribute or a primary key column. Please notify a system administrator of this problem.


STEPS
-------
1. Site Management Administrator
2. Sites > Attributes
3. Attribute Group - Multi -Row


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