Can we have different value set for same COA segment ?
Im trying to run the following query for a client -
select id_flex_num, segment_num, segment_name, flex_value_set_id from FND_ID_FLEX_SEGMENTS where id_flex_code = 'GL#' and enabled_flag = 'Y' and application_id = '101' order by 1 -
It has same COA id, structure seems to be the same, but different segment_name and flexfield value. Is this possible?