Previous  Next          Contents  Index  Navigation  Glossary  Library

Key Flexfield Structure View

For a key flexfield, Oracle Applications generates a separate view for each structure of your key flexfield. You specify the view name for your structure in the Key Flexfield Segments form when you define your key flexfield structure. You must specify a name for each structure for which you want to create a view. If you do not specify a view name, Oracle Applications does not generate a view for that structure.

The key flexfield structure view contains a column for each segment in your flexfield structure, and it uses the segment names, not the segment prompts, as view column names. In the view column names, underscores ( _ ) replace all non-alphanumeric characters. For example, "Segment Value" becomes "SEGMENT_VALUE" and "Manager's Title" becomes "MANAGER_S_TITLE".

If the code combinations table contains columns for segment qualifiers, the segment qualifier columns will use the segment qualifier names as view column names, for example GL_ACCOUNT_TYPE.

In addition to the segment and qualifier columns, the view also contains the code combination ID column, START_DATE_ACTIVE, END_DATE_ACTIVE, SUMMARY_FLAG, ENABLED_FLAG, ROW_ID (not ROWID), and all other columns in the code combination table that are not enabled as flexfield columns. The Structure view does not have the structure defining column as all the information in this view pertains to one structure of the flexfield.

See Also

Overview of Reporting on Flexfields Data

Overview of Flexfield Views

Key Flexfield Concatenated Segment View

Descriptive Flexfield View

Creating a Flexfield View

Segment Naming Conventions

Using Flexfield Views to Write a Report

Key Flexfield Views Examples

         Previous  Next          Contents  Index  Navigation  Glossary  Library