Previous  Next          Contents  Index  Navigation  Glossary  Library

Overview of Reporting on Flexfields Data

The Oracle Applications products provide many predefined reports that you can use to report on your organization's financial, manufacturing, and human resources data. However, nearly every organization occasionally needs to create custom reports specific to that organization, and for most of the Oracle Applications products, that data includes flexfields data. Oracle Applications provides two primary methods you can use to report on your flexfields data.

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 use column names that match your segment names and make ad hoc reporting simpler. See: Overview of Flexfield Views.

Flexfields-Oracle Reports 2.5 API

Oracle Applications provides special flexfield user exits you can call from your custom Oracle Reports reports. See: Oracle Reports 2.5 Flexfield Support API.

Standard Request Submission

While Standard Request Submission doesn't necessarily report on flexfields data, it does use flexfield segments as report parameters. See: Overview of Flexfields and Standard Request Submission.

See Also

Overview of Flexfield Views

Key Flexfield Concatenated Segment View

Key Flexfield Structure View

Descriptive Flexfield View

Creating a Flexfield View

Using Flexfield Views to Write a Report

Key Flexfield Views Examples

Descriptive Flexfield View Example

Oracle Reports 2.5 Flexfield Support API

General Methodology

Basic Implementation Steps



Oracle Reports and Flexfields Report-Writing Steps

Flexfield Report Examples

Report 1: Simple Tabular Report

Report 2: Simple Tabular Report With Multiple Structures

Report 3: Tabular Report

Report 4: Master-Detail Report

Report 5: Master-detail Report on Multiple Structures

         Previous  Next          Contents  Index  Navigation  Glossary  Library