The Oracle E-Business Suite 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 E-Business Suite products, that data includes flexfields data. Oracle E-Business Suite provides two primary methods you can use to report on your flexfields data.
When you freeze and compile a flexfield structure, Oracle E-Business Suite 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.
Oracle E-Business Suite provides special flexfield user exits you can call from your custom Oracle Reports reports. See: Oracle Reports Flexfield Support API.
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.