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
FND FLEXSQL
FND FLEXIDVAL
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