Friday, June 3, 2011

Descriptive Flex Field Multi Context

DFF s are simply used for storing additional info which does not have standard location in Oracle. Context structure is frequently used for storing different data depending on another variable. For any DFF a need for conditional use may appear; for example for different organizations different attributes can exist. In this case setting attribute context (a column in the table) as organization id and for organization1 using "attribute2" as "x", "attribute3" as "y" for "organization2" using "attribute2" as "z" is possible.

And think that one of these organizations prefers asking two additional questions for a purchasing category and three different questions for another purchasing category. In this case questions should change depending on two different variables. Multi context structure provides the differentiation of these information depending on more than one variable. It' s usage is mostly needed if the EBS environment has a multiorg structure. Because companies usually keep different information depending on different variables even though they are under the same rack. To use this structure in Forms a global attribute should be defined via personalization and DFF context should reference to this global attribute. For OAF it may use a Table typed Value Set which has a dynamic query.

No comments:

Post a Comment