Skip to the content.

FND Histogram Columns – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Application Object Library · all Application Object Library reports

Overview

Data from table fnd_histogram_cols, which Oracle uses to identify columns which are expected to have highly skewed data, for example a status column having a large number of closed, but only a small number of open records. The Gather Schema and Gather Table Statistics concurrent programs use this information to create additional histrogram statistics for these columns.

To add a column to this table, use the following API: declare l_table_name varchar2(30):=’AP_INVOICES_ALL’; l_column_name varchar2(30):=’ORG_ID’; begin for c in ( select fpi.application_id from fnd_oracle_userid fou, fnd_product_installations fpi where xxen_util.instring(xxen_api.object_owner_type(l_table_name),’.’,1)=fou.oracle_username and fou.oracle_id=fpi.oracle_id ) loop fnd_stats.load_histogram_cols( action =>’INSERT’, appl_id =>c.application_id, tabname =>l_table_name, colname =>l_column_name, commit_flag =>’Y’); end loop; end;

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Application, Table Name

Oracle EBS Tables Used

fnd_histogram_cols, fnd_application_vl, fnd_product_installations, fnd_oracle_userid

Report Categories

Enginatics

FND Lookup Search, FND Audit Setup, DBA Users, FND Applications, FND Data Groups, CAC Accounting Period Status, FND Concurrent Requests, CAC Interface Error Summary

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output FND Histogram Columns 04-Apr-2026 123137.xlsx
Blitz Report™ XML Import FND_Histogram_Columns.xml
SQL Source FND Histogram Columns.sql
Full Report on Enginatics www.enginatics.com/reports/fnd-histogram-columns/

Case Study & Technical Analysis: FND Histogram Columns

Executive Summary

This report lists the table columns registered in the Oracle Application Object Library table FND_HISTOGRAM_COLS. These are the columns that Oracle expects to hold highly skewed data, such as a status column with many closed rows and only a few open ones. For each registration it shows the application, the schema owner, the table and column, the histogram size and the audit details. It is used by DBAs and EBS technical teams who tune the statistics gathered on the database, and who need to check which columns already receive histogram statistics before adding new ones.

Business Challenge

The Solution

Technical Architecture (High Level)

Primary Tables

Logical Relationships

  1. FND_HISTOGRAM_COLS is joined to FND_APPLICATION_VL on application identifier, which gives the application name.
  2. The same application identifier is joined to FND_PRODUCT_INSTALLATIONS.
  3. The Oracle user identifier from the installation record is joined to FND_ORACLE_USERID, which gives the schema owner.
  4. The result is ordered by application name, table name and column name.

Parameters & Filtering

Performance & Optimization

FAQ

Q: How do I find out which columns already have histogram statistics defined? A: Run the report without parameters. Each row is a column registered in FND_HISTOGRAM_COLS, with its table, column and histogram size.

Q: How do I see the histogram columns of one EBS product? A: Choose the product in the Application parameter. The owner column shows the Oracle schema of that product.

Q: How do I add a column to this list? A: Columns are added through the FND_STATS loadhistogramcols API with the INSERT action, which takes the application identifier of the product that owns the table, the table name and the column name. The report then shows the new row.


© Enginatics GmbH