I have a audit requirement to get a list of all descriptive flexfields defined in the system (custom/standard) with details.
Is there a standard setup report available or may be a custom sql if anyone has developed, for similar requirement?

Shiva

Not sure if it covers the entire system, but in (R12) Order Entry there is apparently an Oracle Reports concurrent program called 'Descriptive Flex Listing' - also not sure if it's available in R11.5, but might at least be a reasonable basis for a custom version?

Shiva, what 'details' would be expected in this report?

All I wanted was DFF names and segments
I updated on OAUG email and got the below query which is somewhat useful.

--------------------------
SELECT dff.descriptive_flexfield_name,
dff.application_table_name,
app.application_short_name app,
u.descriptive_flex_context_code,
u.application_column_name,
u.end_user_column_name
FROM fnd_descr_flex_column_usages u,
fnd_descriptive_flexs dff,
fnd_application app
WHERE u.descriptive_flexfield_name NOT LIKE '$SRS$.%'
AND dff.descriptive_flexfield_name = u.descriptive_flexfield_name
AND app.application_id = dff.table_application_id
--AND dff.application_table_name = 'OE_ORDER_HEADERS_ALL'
--and u.descriptive_flexfield_name = 'RA_ADDRESSES_HZ'
ORDER BY app.application_short_name,
descriptive_flexfield_name,
descriptive_flex_context_code,
TO_NUMBER (REGEXP_REPLACE (u.application_column_name,
'[^0-9]'))

thanks for qry