Previous  Next          Contents  Index  Navigation  Glossary  Library

Descriptive Flexfield View

For a descriptive flexfield, Oracle Applications generates a view named TABLE_NAME_DFV, where TABLE_NAME is the name of the table that contains the descriptive flexfield segment columns. The table name is truncated if necessary so that the view name does not exceed the maximum permissible length of SQL object names (30). For example, the descriptive flexfield that appears on the Segment Values form uses the table FND_FLEX_VALUES, so its resulting view is named FND_FLEX_VALUES_DFV.

The descriptive flexfield view into the underlying table contains a column for each segment in your descriptive flexfield structure. Since this view contains columns for all the segments of all structures of the descriptive flexfield, the view also includes a copy of the structure defining column to differentiate among rows for different structures.

The view uses each structure's segment names as view column names. The context (structure) column uses the context prompt as the view column name (this may be something like "Context_Value" or "Client_Type"). In the view column names, underscores ( _ ) replace all non-alphanumeric characters. For example, "Context Value" becomes "CONTEXT_VALUE" and "Manager's Title" becomes "MANAGER_S_TITLE".

If segments in different structures (contexts) have identical names, these segments share the same view column. If two or more segments share a view column, then these segments should use value sets of the same format type.

The Descriptive Flexfield View also shows the concatenated segment values in the flexfield as a single column in the view. That column also contains the context value as a "segment" value. The CONCATENATED_SEGMENTS column contains global segments (if any are enabled), the context value, and any context-sensitive segments, in that order. The view does not contain any other columns from the underlying table except a ROW_ID (not ROWID) column, the context column and the columns that are used by enabled segments. The ROW_ID column in the view corresponds to ROWID in the actual table.

See Also

Overview of Reporting on Flexfields Data

Overview of Flexfield Views

Key Flexfield Concatenated Segment View

Key Flexfield Structure View

Creating a Flexfield View

Segment Naming Conventions

Using Flexfield Views to Write a Report

Descriptive Flexfield View Example

         Previous  Next          Contents  Index  Navigation  Glossary  Library