ERPstuff - Oracle EBS Community

hi,

i have a requirement where i need to display flexfield information.
which table stores this information.
also need to display segment description in GL. how to do that.
can plz anyone help me

thanks,
venkat

Hi Venkat,

If you want to print the flex field information in Oracle Reports you can use the user exit <font color="red"><b>FND FLEXSQL</b></font id="red">.

I'm giving you a small example of how to use this user exit.
<font color="red"><b>
SRW.User_Exit(?FND FLEXSQL
APPL_Short_Name=?GL?
Code=?GL#?
NUM=?:P_Struct_Num?

Output=?:P_FlexData?
Mode=?Select?
Display=?All? ?);
</b></font id="red">

Pass the parameters as required and you will get the flex field information.

The tables where flexfields are stored are as follows:

<font color="red"><b>Key Flex Fields:
1.fnd_flex_values_tl,
2.fnd_id_flex_segment,
3.fnd_flex_value_sets,
4.fnd_id_flex_structure,
5.fnd_id_flexs</b></font id="red">


<font color="red"><b>Descriptive Flex Fields:
1.FND_DESCRIPTIVE_FLEXS,
2. FND_DESCR_FLEX_CONTEXT,
3. FND_DESCR_FLEX_COLUMN_USAGES</b></font id="red">

<font color="blue"><b>Best Regards & Thanks,
Arun Reddy</b></font id="blue">