Descriptive Flexfield Analytics for Oracle BI & Oracle E-Business Suite

KPI has developed a pre-built analytic application specifically designed for Oracle E-Business Suite Descriptive Flexfields

What are Descriptive Flexfields (DFF)?

Oracle EBS DFFFlexfields are customizable fields within Oracle Applications that allow organizations flexibility to the way they do business, as opposed to attempting to make each organization conform to a “one size fits all” philosophy.

Descriptive Flexfields provide customized “expansion space”. You can use Descriptive Flexfields to track additional information, important and unique to your business, that would not otherwise be captured.


KPI Partners has developed a pre-packaged Descriptive Flexfield Analytics solution for use on the Oracle Business Intelligence platform. Using the solution with Oracle E-Business Suite enables any organization to review all the Descriptive Flexfields information stored in the source system. Analyze all the Descriptive Flexfields in a selected module, a selected table, or by individual Descriptive Flexfield.


Descriptive Flexfield Analytics is fully integrated with Oracle’s BI Application platform and is compliant with standards for Oracle ETL and BI metadata.


Descriptive Flexfield Analytics is well integrated with all Oracle E-Business Suite and Oracle BI Applications.


A typical analysis of an organization’s DFF can be cumbersome. Descriptive Flexfield Analytics eliminates the need for users to run many different queries and facilitates simplified analysis from a single dashboard.

Descriptive Flexfield Analytics provides source table and column information for each Descriptive Flexfield defined in the source system. ETL development efforts can be reduced by nearly 50% as the column lineage can be directly derived from Descriptive Flexfields Analytics reports.

Key Functionality

Descriptive Flexfield Analytics is delivered with out-of the-box conformed dimensions and features the following functionality:

  • Analysis of all Descriptive Flexfields defined in a particular module of the source system. 
  • Analysis of all Descriptive Flexfields defined in a particular table in the source system. 
  • Analyze individual Descriptive Flexfields in detail. 
  • When used in conjunction with data lineage and imact analysis tools, it can reduce ETL and report development efforts by as much as 50%.