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:
- Key Flexfield Concatenated Segments View
- Key Flexfield Structure View
Descriptive Flexfields
A descriptive flexfield has one view:
- Descriptive Flexfield 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