Previous  Next          Contents  Index  Navigation  Glossary  Library

Overview of Flexfield Views

When you freeze and compile a flexfield structure, Oracle Applications automatically generates one or more database views of the appropriate flexfield tables. These views make ad hoc reporting simpler by providing view columns that correspond directly to your flexfield segments. You can use these views for your reporting by joining them to other application tables that contain flexfield-related data such as code combination ID numbers (CCIDs).

The segment columns in the views use the segment names (not the segment prompts) you define using the (Key or Descriptive) Flexfield Segments forms. Each column has a data type that matches the segment's value set format type, regardless of whether the actual segment column matches that data type. Segments that do not use a value set or use a value set with a hidden ID use the same view column type as the underlying table column. See: Key Flexfield Segments, Descriptive Flexfield Segments.

Key Flexfields

Key Flexfields can have two views into the code combination table:

Descriptive Flexfields

A descriptive flexfield has one view:

See Also

Overview of Reporting on Flexfields Data

Key Flexfield Concatenated Segment View

Key Flexfield Structure View

Descriptive Flexfield View

Creating a Flexfield View

Segment Naming Conventions

Using Flexfield Views to Write a Report

Key Flexfield Views Examples

Descriptive Flexfield View Example

         Previous  Next          Contents  Index  Navigation  Glossary  Library