ERPstuff - Oracle EBS Community

Hello all,

I am trying to find the meaning of the values that are being stored in GL_code_Combinations table. For example, segment1 stores the fund value, segment2 may store budget fiscal year.

Is there some kind of look up values for these.

Thanks for your time.

Ram

Hi,

Please check with following query.

SELECT DISTINCT(ffv.FLEX_VALUE),ffv.DESCRIPTION
FROM fnd_id_flex_segments fis,FND_FLEX_VALUES_vl ffv
WHERE fis.FLEX_VALUE_SET_ID=ffv.FLEX_VALUE_SET_ID
AND END_DATE_ACTIVE IS NULL
AND fis.SEGMENT_NAME=' key flexfield Segment name'

if any more queries please let me know.

Thanks & Regards,

Siva

Hello Siva,

Thank you for your reply. I was actually trying to find it from applications side, but this one also helped me.

Thank you for your time.

Ram