Can content set in FSG report to reference dependent value set assigned to a specific COA segment ?
Hi all,
We have a FSG report which included a content set definition that will reference to a COA segment and the value set for this COA segment is a dependent value set. When we run the FSG report, the report failed with the following error :
saulas.saulas:
Query for values of segment from validation table 3
SELECT DISTINCT substr(a.FLEX_VALUE,8,2) Value FROM FND_FLEX_VALUES a, FND_FLEX_VALUES_VL b
where a.ENABLED_FLAG = 'Y'
and a.FLEX_VALUE_SET_ID = 1013561
and a.FLEX_VALUE_ID = b.FLEX_VALUE_ID
and a.ATTRIBUTE1 = :$FLEX$.PNGPOWER_GL_DEPARTMENT AND substr(a.FLEX_VALUE,8,2) BETWEEN '00' AND 'ZZ' ORDER BY substr(a.FLEX_VALUE,8,2) DESC
We have a FSG report which included a content set definition that will reference to a COA segment and the value set for this COA segment is a dependent value set. When we run the FSG report, the report failed with the following error :
saulas.saulas:
Query for values of segment from validation table 3
SELECT DISTINCT substr(a.FLEX_VALUE,8,2) Value FROM FND_FLEX_VALUES a, FND_FLEX_VALUES_VL b
where a.ENABLED_FLAG = 'Y'
and a.FLEX_VALUE_SET_ID = 1013561
and a.FLEX_VALUE_ID = b.FLEX_VALUE_ID
and a.ATTRIBUTE1 = :$FLEX$.PNGPOWER_GL_DEPARTMENT AND substr(a.FLEX_VALUE,8,2) BETWEEN '00' AND 'ZZ' ORDER BY substr(a.FLEX_VALUE,8,2) DESC
0