Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

COMPILED_VALUE_ATTRIBUTES field in table fnd_flex_values

Hi Guys

Does anyone please have a list of what each attribute is in the COMPILED_VALUE_ATTRIBUTES field in table fnd_flex_values?

Data Source : ApplicationDB_FSCM

E.G.
COMPILED_VALUE_ATTRIBUTES (Y N N A N N ) <————————————————————————

I need to know what is in each position, like this:

Position 1 = ALLOW_POSTING

Position 3 = ALLOW_BUDGETTING etc.

Thank you!

——————————————————————

Sample SQL:

SELECT DISTINCT
b.flex_value as Value,
c.description value_description,
b.enabled_flag,
START_DATE_ACTIVE,
END_DATE_ACTIVE,
ATTRIBUTE_SORT_ORDER,
SUMMARY_FLAG,

b.COMPILED_VALUE_ATTRIBUTES

FROM fnd_flex_value_sets a ,
fnd_flex_values b ,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!